Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Problem: Big Al Plastics produces a variety of plastic items for packaging and distribution. One item, container #145, has had a low contribution to profits.
Problem: Big Al Plastics produces a variety of plastic items for packaging and distribution. One item, container #145, has had a low contribution to profits. Last year, 20,000 units of container #145 were produced and sold. The selling price of the container was $32 per unit, with a variable cost of $16 per unit and a fixed cost of $95,000 per year. 2. (25 pts) Create a copy of the Question 1 worksheet in the same workbook. Rename this copy Question 2. Using the Question 2 worksheet, find the amount of units to break-even. Ensure you have used Goal Seek in order to find this quantity. b. Provide a screenshot of the Goal Seek Dialog Box in A17:C27. Only provide the Goal Seek dialog box. In the textbox E4:J12, provided an explanation of the analysis that was performed. a. C. Inputs Response: Unit Sales Price Annual Fixed Cost Unit Variable Cost Quantity Made and Sold Calculations and Outputs Annual Revenue Annual Variable Costs Annual Fixed Cost Annual Total Cost Annual Profit (Loss) Documentation Question 1 Question 4 +
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