Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Passive Activity Loss IRS Audit Technique Guide

Authors: Internal Revenue Service

1st Edition

1304114325, 978-1304114327

More Books

Students also viewed these Accounting questions