Hello Company makes three different products. Due to the constraints of their manufacturing equipment and warehouse...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Hello Company makes three different products. Due to the constraints of their manufacturing equipment and warehouse facility, the company is only able to produce, store, and sell a total of 50,000 units each month. The production of Products A and B varies each month; however, Product Cisa special order for one customer who purchases the same number of units every month. Pete Davila, the CEO, has provided the following data from last Product C Max Capacity Income Statement Units Product A Product B 43,000 10.00 $ 5,000 2,000 50,000 Price per unit Variable expense per unit 8.00 $ 50.00 15.00 10,000 3.00 $ 2.00 $ Total Fixed Costs 20,000 $ 40,000 $ 430,000 $ (129,000) $4 40,000 $ (10,000) 30,000 $ Product Sales Variable Costs Contribution Margin 100,000 $ 570,000 (30,000) 70,000 $ 401,000 (169,000) 301,000 $ (20,000) (40,000) (10,000) Fixed Costs (70,000) (10,000) 60,000 $ 331,000 Operating income (loss) 281,000 Required Using the Data Table What-If Analysis tool in Excel, determine the Units and Operating Income (Loss) for each product base 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 40,000 units and a maximum of 45,000 units. Product Bcan vary between 3,000 units and a maximum of 8,000 units. Both Products A and B are manufactured in 1,000-unit increments. The production level of Product Cis the same each month at 2,000 units. Operating Income (Loss) SCENARIO 1 Product A Product B Product C Units ? ? Scenario 2: Pete wants each product line in the mix to be profitable. Use a One Variable Data Table to determine the number of units for each product that should be produced (to the nearest thousand) to make each product line profitable. Operating Income (Loss) SCENARIO 2 Product A Product B Product C Units ? ?. Based on your calculations above, which scenario creates the highest overall Operating Income for the company? Hello Company makes three different products. Due to the constraints of their manufacturing equipment and warehouse facility, the company is only able to produce, store, and sell a total of 50,000 units each month. The production of Products A and B varies each month; however, Product Cisa special order for one customer who purchases the same number of units every month. Pete Davila, the CEO, has provided the following data from last Product C Max Capacity Income Statement Units Product A Product B 43,000 10.00 $ 5,000 2,000 50,000 Price per unit Variable expense per unit 8.00 $ 50.00 15.00 10,000 3.00 $ 2.00 $ Total Fixed Costs 20,000 $ 40,000 $ 430,000 $ (129,000) $4 40,000 $ (10,000) 30,000 $ Product Sales Variable Costs Contribution Margin 100,000 $ 570,000 (30,000) 70,000 $ 401,000 (169,000) 301,000 $ (20,000) (40,000) (10,000) Fixed Costs (70,000) (10,000) 60,000 $ 331,000 Operating income (loss) 281,000 Required Using the Data Table What-If Analysis tool in Excel, determine the Units and Operating Income (Loss) for each product base 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 40,000 units and a maximum of 45,000 units. Product Bcan vary between 3,000 units and a maximum of 8,000 units. Both Products A and B are manufactured in 1,000-unit increments. The production level of Product Cis the same each month at 2,000 units. Operating Income (Loss) SCENARIO 1 Product A Product B Product C Units ? ? Scenario 2: Pete wants each product line in the mix to be profitable. Use a One Variable Data Table to determine the number of units for each product that should be produced (to the nearest thousand) to make each product line profitable. Operating Income (Loss) SCENARIO 2 Product A Product B Product C Units ? ?. Based on your calculations above, which scenario creates the highest overall Operating Income for the company?
Expert Answer:
Answer rating: 100% (QA)
Solution All calculation for Hello Company a General constraint Warehouse capacity is 50000 units b ... View the full answer
Related Book For
Managerial Economics A Problem-Solving Approach
ISBN: b00btm8fk0
2nd edition
Authors: Luke M. Froeb, Brain T. Mccann
Posted Date:
Students also viewed these accounting questions
-
The Ritz Furniture Gallery, Inc., provided the following data from the companys records for the year ended December 31, 2014: a. Credit sales, $560,100 b. Loan to another company, $7,900 c. Cash...
-
Dellroy Digital Services, Inc., has provided the following data from the companys records for the year just ended December 31: a. Collection of...
-
Accurate Digital Services, Inc., has provided the following data from the companys records for the year just ended December 31: a. Collection of...
-
You work as a manager in the admission department of company. You were asked by your department head to present and analyze the qualifying test scores of 40 employees who are applying for 5-year...
-
The following is the stockholders equity of Piesco Corporation on October 1, 201X: 1. Journalize the transactions in general journal form. 2. Prepare the stockholders equity section of the balance...
-
For each scenario, determine when to recognize revenue. a. Top Notch Processing, Inc. enters into a contract to provide monthly accounting services to a customer for one year. b. A customer purchased...
-
Discuss the pros and cons of a 360 - degree evaluation of the chief executive s performance.
-
On October 5, Narveson Company buys merchandise on account from Rossi Company. The selling price of the goods is $5,000, and the cost to Rossi Company is $3,000. On October 8, Narveson returns...
-
Discuss with relevant examples the extent to which the currency area hypothesis drives foreign direct investment flows across countries.
-
You are working on a free-form Packet Tracer challenge activity as seen in Figure 1, you have been given the London Railways network.' The purpose of this EMA question is to build upon each of the...
-
The partnership of frick Wilson and Clarke has elected to cease all operations and liquidate the business property A balance sheet drawn up at this time shows the following account balances Cash % 6...
-
Marketers continue to explore new ways to better understand how customers behave by using big data and analytics to help a business predict consumer behavior and understand the perceived value that...
-
VitexIncorporated manufactures a popular consumer product and it has provided the following data excerpts from its standard cost system: Inputs Direct materials Direct labor Variable manufacturing...
-
Here are selected 2 0 2 2 transactions of Bramble Company.Jan . 1 Retired a piece of machinery that was purchased on January 1 , 2 0 1 2 . The machine cost $ 6 2 , 0 0 0 and had a useful life of 1 0...
-
Larned Corporation recorded the following transactions for the just completed month. a. Purchased $78,000 of raw materials on account. b. $76,000 in raw materials were used in production. Of this...
-
Chemical Engineering Electrical Engineering 47566.41 55343.45 57511.62 42283.1 49072.4 51514.75 56444.62 53061.35 54530.1 55644.15 58204 53334.17 66599.1 57280.48 58717.98 53215.74 47901.59 49282.19...
-
What are current assets and current liabilities? How are they different from non-current assets and non-current liabilities?
-
An artificial tooth manufacturer sells teeth to distributors through a dealer network. The dealers sell to dental labs, which construct dentures for consumers. The manufacturer has spent a great deal...
-
Soft selling occurs when a buyer is skeptical of the quality or usefulness of a product or service. For example, suppose youre trying to sell a company a new accounting system that will reduce costs...
-
In 1998, the Syndicated Bank Loan market (defined as loans having more than two bank lenders) was a vast and cheap source of debt financing for U.S. corporations. This market was characterized by a...
-
Which document lists the components needed to manufacture a specific product? a. operations list b. master production schedule c. bill of materials d. production order
-
This chapter noted many of the benefits that can arise by integrating the HRM and payroll databases. Nevertheless, many companies maintain separate payroll and HRM information systems. Why do you...
-
Most costs are locked in at which stage in the production cycle? a. product design b. production planning c. production operations d. cost accounting
Study smarter with the SolutionInn App