Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The company is considering ways to improve profitability by either stimulating sales volume or reducing variable costs. There are two alternatives. Alternative 1: Sales (Quantity
The company is considering ways to improve profitability by either stimulating sales volume or reducing variable costs. There are two alternatives. Alternative 1: Sales (Quantity Made and Sold) can be increased by 35% of their current levels. Alternative 2: Variable costs can be decreased by 20%. Assuming all other costs stay at the base-case levels (values established in question 1), use the model to determine which alternative would lead to a higher profit contribution. O 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. 3. (25 pts) Create a copy of the Question 1 worksheet. Rename this copy Question 3. Using the Question 3 worksheet, construct a data table showing profit versus quantity. Also, create a chart that will show the created data table in graphical form. a. Vary the quantity from 0 to 70,000 in increments of 5,000 for the data table. b. Put the data table in columns E and F. (You can delete the text box) Ensure there are headers on the data table for easy reading. d. Put the chart in H4:019. Ensure the chart has a meaningful title. 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