Project Overview You will complete a Calculations and Report Document for this project. In part one , you will represent problems as mathematical expressions that you will then solve. In part two ,...

1 answer below »


Project Overview


You will complete aCalculations and Report Documentfor this project. Inpart one, you will represent problems as mathematical expressions that you will then solve. Inpart two, you will explain what your calculations mean and how they inform your thinking about the problems. The ability to solve problems with math will help you with everything from managing your finances to baking new recipes.





Competency


In this project, you will master the following competency:



  • Use basic quantitative methods of problem solving





Scenario


You work at All-Store, a large general store that sells everything from groceries and office supplies to medicine, toys, and books. Unfortunately, the company’s profits have been down for the last six months because of competition, specifically from other local businesses and online vendors.



Jill Oliviera, All-Store’s general manager, has decided to rethink the store’s business strategies. One of her new ideas is to focus the business on just a few departments. This way, All-Store can specialize in those areas rather than continuing to support all of the current offerings.


Due to declining sales and the upcoming changes, Jill is worried about the business’s finances. She’s given you access to several company files and asked you to prepare a report. Your report should cover different situations that the business may face in the coming months.





Directions


Your manager is looking for your recommendations for how the store could best respond to: declining sales, reducing staffing, and purchasing the building.


To do this, download and fill out theCalculations and Report Documentin the “What to Submit” section.


As you completepart oneof this document, break down each of the three problems individually. When representing problems as expressions, don’t be afraid to try a few equations for each step to see what works. Use information and data from the company files in the “Supporting Materials” section to answer the questions.


Inpart two, give your recommendations to your manager: what do you think the company should do about declining sales, reducing staffing, and purchasing the building? Be sure to support your recommendations with quantitative evidence. Then, explain how you used mathematical expressions to solve these problems.


When you have completed both parts of the Calculations and Report Document, you can submit it as your deliverable.





What to Submit


Every project has a deliverable or deliverables, which are the files that must be submitted before your project can be assessed. For this project, you must submit the following:



Calculations and Report Document

Download and complete theCalculations and Report Document. Make sure that you have answered all of the questions in part one and part two.


Answered 5 days AfterMar 16, 2021

Answer To: Project Overview You will complete a Calculations and Report Document for this project. In part one...

Tanmoy answered on Mar 18 2021
162 Votes
19DA09
All-Store Calculations and Report
Note: Complete this worksheet by replacing the bracketed phrases in the response boxes with the relevant information.
Name:
You need to analyze three areas of the All-Store business: declining sales, reducing staffing, and purchasing the building. Before you start, read all of the All-Store company documents in the “Supporting Materials” section. These will have useful information that will help you complete your project.
Note: You can use a calculator to complete the calculations. Make sure to show and check all of your work.
Part 1: Your Calculations

Declining Sales
The general manager wants to know what the impact will be on the business if sales continue to decline at the current rate and no action is taken. This can be broken down into two questions:
· How long will it be before All-Store starts operating at a loss?
· How long will it be before All-Store goes bankrupt?
How Long Before All-Store Starts Operating at a Loss?
When a company makes less money than it spends, this is referred to as operating at a loss. Another way to express this is “the net profit equals zero.”
When will All-Store’s monthly profit equal zero? Although there’s no precise answer to this question, since the future is unpredictable, you can estimate based on some available data. In the following steps, you will estimate the monthly drop in profits. Then, you’ll formulate a projection to determine when All-Store would be operating at a loss.
Monthly Net Profit
List each month’s net profit in the following response box.
    January $135,970.66
February $129,832.81
March $120,896.73
April $108,024.43
May $109,442.14
June $93,514.22
Difference between Monthly Net Profits
Calculate the difference between each month’s net profits. For example, subtract January’s profit from February’s profit. Then subtract February’s profit from March’s profit. Continue this process for each month.
    ($1,29,832.81 - $1,35,970.66) = -$6,137.85
($1,20,896.76 - $1,29,832.81) = -$8,936.08
($1,08,024.43 - $1,20,896.76) = -$12,872.30
($1,09,442.14 - $1,08,024.43) = $1,417.71
($93,514.22 - $1,09,442.14) = -$15,927.92
Profit Drop
Determine how much profits will drop in the following months. You’ll need to estimate based on all of the previous numbers. One way to do this is by choosing a number that represents something close to the middle of the values, or a measure of central tendency. Mean, median, and mode are three different measures of central tendency. Calculate each measure in the following response box.
To calculate the mean (average):
· Add all of the numbers in the series together.
· Divide them by the quantity of numbers added.
· Note: You may need to round up or down to the nearest cent.
To calculate the median (middle):
· List all of the numbers in the series in order (low to high, or high to low).
· Choose the one in the middle of the list.
To calculate the mode (most frequent):
· List all of the numbers in order (from lowest to highest or highest to lowest).
· Choose the number that appears the most often. If no numbers repeat in a series, then there is no mode.
    Mean =[ $6137.85 + $8936.08 + $12872.30 + (-$1417.71) + $15927.92/5] = $42456.44 /5 = $8491.29
-$1417.71; $6137.85; $8936.08; $12872.3; $15927.92
Median = $8936.08
In this case I have arranged the numbers in #2 in ascending order and chosen the middle number which is $8936.08.
Mode: There is no mode in this case
Mode of Central Tendency Used to Predict the Upcoming Months
· Which value(s) will you use to make your projections? Why?
· Is there value in showing more than one projection in your report? Why or why not?
    I choose median since median represents the number which is much closer to the middle of the numbers in the above figures I have available with. Therefore, median is $8936.08.
Projection
Now that you’ve chosen a way (or ways) to estimate, it’s time to project the month. To do this:
· Divide the last number in the series (the net profit from June) by the measures of central tendency you calculated in question 3.
· If there is a decimal in your result, round down to the nearest month.
    $93,514.22/$8491.29 = 11
= 11 is nearest to the month of November
How Long Before All-Store Goes Bankrupt?
Bankruptcy is when a person or company runs out of money and cannot afford to pay the bills. It can also refer to the legal processes involved in dealing with this situation. For All-Store, bankruptcy could include missing payments on anything from rent to payroll. In this section, you will use your estimate for the monthly drop in profits, which you already calculated, to project when this will occur.
All-Store Savings
Find the current amount of funds that All-Store has in savings. Read the company documents in the “Supporting Materials” section to learn this information.
    The current amount of funds that All-store has in savings is $50,546.43
How Long All-Store Can Operate at a Loss
Although the company will be operating at a loss, All-Store has some money in savings that will allow it to pay for expenses for a time. In the response box, determine this time in months. To do this:
· Add the amount in savings to the net profit from June.
· Divide by the number(s) you determined above (mean, median, mode).
· If there is a decimal in your result, round down.
    = $50,546.43 + $93,514.22 = $144060.65
= $144060.65/$8491.29 = 16
= $144060.65/$8936.08 = 16
There was no mode
Summary
Reflect on the meaning of your calculations. Consider the following questions:
· What do you think the results of your calculations will mean for the company?
· What specific actions would you recommend based on all of the available information? For example, what is a specific way for the company to cut costs?
    As per the calculations it can be stated that the company must reduce the expenses in order to avoid the running of the company out of money. The best way to reduce the expenditure is to reduce the number of employees. They can also reduce the...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here