Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. on the data tables - student tab in your excel spr

On the Data Tables - Student tab in your Excel spreadsheet, update the given information...

70.2K

Verified Solution

Question

Accounting

On the Data Tables - Student tab in your Excel spreadsheet, update the given information section of the Income Statement for Hello Company with the data below:
\table[[Income Statement,Product A,Product B,Product C,\table[[Max],[Capacity]]],[Units,40,000,7,000,3,000,50,000],[Price per unit,$11.00,$9.00,$60.00,],[Variable expense per unit,$3.00,$3.00,$20.00,],[Total Fixed Costs,$20,000,$40,000,$10,000,]]
Required:
2. Using the Data Table What-If Analysis tool in Excel, determine the Units and Operating Income (Loss) for each product based on the following scenarios. (Hint: Don't forget that the warehouse can only hold up to 50,000 units.)
Scenario 1: Pete wants to find the mix of units that will result in the highest overall Operating Income, perform this analysis using a two variable data table. Product A can vary between 37,000 units and a maximum of 42,000 units. Product B can vary between 5,000 units and a maximum of 10,000 units. Both Products A and B are manufactured in 1,000-unit increments. The production level of Product C is the same each month at 3,000 units.
\table[[SCENARIO 1,Units,\table[[Operating],[Income (Loss)]]],[Product A,,],[Product B,,],[Product C,,],[,,]]
image

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students