Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribedimage text in transcribedimage text in transcribed

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

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

Conflict Management And Negotiation Skills For Internal Auditors

Authors: Joan Pastor, PhD

1st Edition

0894136089, 978-0894136085

More Books

Students also viewed these Accounting questions

Question

Develop a program for effectively managing diversity. page 303

Answered: 1 week ago

Question

List the common methods used in selecting human resources. page 239

Answered: 1 week ago