Answered step by step
Verified Expert Solution
Question
1 Approved Answer
New Era Medical COMPLETE A BUDGET SUMMARY WORKSHEET of GETTING STARTED Open the file SC _ EX 1 9 _ 1 a _ FirstLastName _
New Era Medical
COMPLETE A BUDGET SUMMARY WORKSHEET
of GETTING STARTED
Open the file SCEXaFirstLastNamexIsx, available for download from the
SAM website.
Save the file as SCEXaFirstLastNamexIsx by changing the to a
If you do not see the xlsx file extension in the Save As dialog box, do not type it
The program will add the file extension for you automatically.
With the file SCEXaFirstLastNamexIsx still open, ensure that your first
and last name is displayed in cell B of the Documentation sheet.
If cell B does not display your name, delete the file and download a new copy
from the SAM website.
PROJECT STEPS
Josh Bartel is the senior director of the Pennsylvania field office for New Era Medical, a
global company that manufactures medical equipment. He has created a worksheet
summarizing the revenue and expenses for the first three quarters of the year. He asks
for your help in determining what the Pennsylvania office needs to do to meet its
targeted profit goals in the fourth quarter.
Go to the Budget Summary worksheet. Cut the worksheet title from cell I and paste it
in cell A to display the title in its expected location. B
In cell E add the text Number of so that the complete text appears as "Number of
salespeople:" and more clearly identifies the value in cell G
Enter Quarter in cell and Quarter in cell D
In cell G enter a formula without a function that subtracts the target revenue cell F
from the year to date revenue cell E to determine how much revenue the field office
needs to earn in Quarter to reach its target for the year.
Josh wants to calculate the gross margin for Quarters and the year to date. Provide
this information as follows:
a In cell B enter a formula without a function that divides the gross profit for
Quarter cell B by the revenue in Quarter cell B
b Fill the range C:E with the formula in cell B to find the gross margin for
Quarters and and for the year to date.
Josh needs to sum the sales for each Pennsylvania region for the year to date. Provide
this information as follows:
a In cell E enter a formula that uses the SUM function to total the regional sales
data for the Northeast region the range B:D to calculate the yeartodate
sales.
b Use the Fill Handle to fill the range E:E with the formula in cell E to find the
yeartodate sales for the other three regions.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started