Answered step by step
Verified Expert Solution
Question
1 Approved Answer
PLEASE help me ASAP! The controller for the Lillan Corporation created an Excel worksheet that includod a profit calculation. The worksheet also contained a data
PLEASE help me ASAP!
The controller for the Lillan Corporation created an Excel worksheet that includod a profit calculation. The worksheet also contained a data table crested using the What-if analysis tool to analyze the saies price, volume, and profit related to the graphics card the company manufactures. The worksheets are pictured next. (Cick the icon to view the profit calculation.) Click the ioon to view the What-if analysis.) Read the requirements. a. Describe the steps you would follow to create the Profit calculation portion of the worksheet. Within the Profit calculation portion of the worksheot pictured, which cells would contain formules? Specify each cell that would contain a formula and what each of those formulas would be. (if an input field is not used in the table leave the input fiold ernptys do not select a label or enter a zero.) Requirements Using the worksheet pictured above, answer the following questions: a. Describe the steps you would follow to create the Profit calculation portion of the worksheet. Within the Profit calculation portion of the worksheet pictured, which cells would contain formulas? Specify each cell that would contain a formula and what each of those formulas would be. b. Describe the steps you would follow to create the Data table portion of the worksheet pictured. c. What is the current break even volume of sales if the selling price remains at $50 ? How do you know? d. If the company raises the selling price to $60 and sells 600 units, what would be the operating income? e. If the company's suppliers increase the cost of direct materials, would you expect the table to contain the same, fewer, or more shaded cells? f. If the company can negotiate lower plant property taxes with the county, would you expect the table to contain the same, fewer, or more shaded cells? g. If the company increased its target profit goal to $15,000 per month, would you expect the table to contain the same, fewer, or more shaded cells? Profit calculation What-if analysis a. Describe the steps you would follow to create the Profit calculatio contain formulas? Specify each cell that would contain a formula and select a label or enter a zero.) Cell B3 would contain the formula =B2B5 Cell B3 would contain the formula =B10/B2 Cell B4 would contain the formula =B2+B3 Cell B4 would contain the formula =B2B3 Cell B4 would contain the formula =B2B3 Cell B6 would contain the formula =B4+B5 Cell B6 would contain the formula =B4B5 Cell B6 would contain the formula =B5/B4 Cell B8 would contain the formula =B6B7 Cell B8 would contain the formula =B6B7 Cell B8 would contain the formula =B6/B7 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