Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hello! Please help fill in both Industry boxes, Costs to Double Capacity, and Cost to Raise Automation to 10.0. Thank you in advance! :) Capacity

Hello! Please help fill in both Industry boxes, Costs to Double Capacity, and Cost to Raise Automation to 10.0. Thank you in advance! :)

image text in transcribed

image text in transcribedimage text in transcribed

Capacity Analysis Capacity Analysis Being able to analyze plant and equipment (capacity and automation) is essential to understanding how you and your competitors are supplying the market demand. There is often unmet demand in segments because companies do not or cannot produce enough units. If you successfully analyze industry capacity, your team could benefit from these shortfalls. Each product has its own production line where you can set capacity and automation. Capacity represents the company's ability to produce units of its product. Think of capacity as your manufacturing plant. For each unit of capacity, there are two shifts of workers that can use your manufacturing plant to produce your products, which represents a first and second shift. So if your product has a capacity of 1000, this means you can produce up to 2000 units of your product. Automation represents the robot-to-worker ratio in your manufacturing plant. A higher ratio of robots will provide your company with a lower labor cost. However, this will increase the amount of time it takes your products to be updated. You will need: The Production Analysis report (page 4) of the FastTrack for Round 0 On the Production Analysis page, look at the table of products (the Andrews company is displayed). The highlighted boxes (plus a little math!) are where you will find the information you need to complete the analysis. 2nd Shift Automation Capacity Primary Units Unit Revision Age Pfmn Size Material Labor Contr. & Next Next Plant Name Segment Sold Inventory Date Dec.31 MTBF Coord Coord Price Cost Cost Marg. Overtime Round Round Utiliz. Able Low 1,200 87 11/21/2011 3.1 21000 6.4 13.6 $34.00 $16.17 $10.11 20% 63% 3.0 800 161% Production Costs Activity Use the table with page 4 of the FastTrack to complete the activity. Capacity/Industry Production table First Shift Capacity First and Second Shift Capacity Automation Level Cost to Double Capacity Cost to Raise Automation to 10 Company Found under "Capacity Next Round" Capacity Next Round x 2 (shifts) Increasing capacity is $6 per unit with an adjustment for automation. Increasing automation is per unit of capacity Found under "Automation Next Round" Industry Total the capacity of each product in that segment Total capacity of each product in that segment X 2 Formula is: First Shift Capacity x [$6 + ($4 x automation level)] Example Input: 500 Formula is: First Shift Capacity x [$4 x (10 - automation level)] Example Input: 700 * In the simulation, the input cells are in thousands ('000's), so an input of 1 is actually 1000 units. So, in the example, 500,000 units is inputted as 500 in the cell. This applies to dollar values as well. Incomplete Capacity Analysis Product First Shift Name Capacity Company First & Second Shift Capacity Company Industry Automation Level Cost to Double Capacity Cost to Raise Automation to 10.0 Industry Able 800 0 1600 3 0 0 Production Analysis Fast Track F121332_007 Round: 0 December 31, 2020 Production vs Capacity F121332_007 Andrews Baldwin Chester Digby Erie Ferris 0 100 200 300 400 500 600 700 800 900 1,000 1,100 1.200 Capacity O Production Andrews 1,287 Baldwin 1,287 Chester 1,287 Digby 1,287 Erie 1,287 Ferris 1,287 Units Produced Production Information 2nd Shift Auto Unit & mation Capacity Primary Units Inven Age Size Material Labor Contr. Over Next Next Plant Name Segment Sold tory Revision Date Dec.31 MTBF Coord Coord Price Cost Cost Marg. time Round Round Utiliz. Pfmn Able Low 1,200 87 11/21/2017 3.1 21000 6.4 13.6 $34.00 $16.17 $10.11 20% 63% 3.0 800 161% Baker Low 1,200 87 11/21/2017 3.1 21000 6.4 13.6 $34.00 $16.17 $10.11 20% 63% 3.0 800 161% Cake Low 1,200 87 11/21/2017 3.1 21000 6.4 13.6 $34.00 $16.17 $10.11 20% 63% 3.0 800 161% Daze Low 1,200 87 11/21/2017 3.1 21000 6.4 13.6 $34.00 $16.17 $10.11 20% 63% 3.0 800 161% Eat Low 1,200 87 11/21/2017 3.1 21000 6.4 13.6 $34.00 $16.17 $10.11 20% 63% 3.0 800 161% Fast Low 1,200 87 11/21/2017 3.1 21000 6.4 13.6 $34.00 $16.17 $10.11 20% 63% 3.0 800 161% FOUNDATION FAST TRACK Page 4 Capacity Analysis Capacity Analysis Being able to analyze plant and equipment (capacity and automation) is essential to understanding how you and your competitors are supplying the market demand. There is often unmet demand in segments because companies do not or cannot produce enough units. If you successfully analyze industry capacity, your team could benefit from these shortfalls. Each product has its own production line where you can set capacity and automation. Capacity represents the company's ability to produce units of its product. Think of capacity as your manufacturing plant. For each unit of capacity, there are two shifts of workers that can use your manufacturing plant to produce your products, which represents a first and second shift. So if your product has a capacity of 1000, this means you can produce up to 2000 units of your product. Automation represents the robot-to-worker ratio in your manufacturing plant. A higher ratio of robots will provide your company with a lower labor cost. However, this will increase the amount of time it takes your products to be updated. You will need: The Production Analysis report (page 4) of the FastTrack for Round 0 On the Production Analysis page, look at the table of products (the Andrews company is displayed). The highlighted boxes (plus a little math!) are where you will find the information you need to complete the analysis. 2nd Shift Automation Capacity Primary Units Unit Revision Age Pfmn Size Material Labor Contr. & Next Next Plant Name Segment Sold Inventory Date Dec.31 MTBF Coord Coord Price Cost Cost Marg. Overtime Round Round Utiliz. Able Low 1,200 87 11/21/2011 3.1 21000 6.4 13.6 $34.00 $16.17 $10.11 20% 63% 3.0 800 161% Production Costs Activity Use the table with page 4 of the FastTrack to complete the activity. Capacity/Industry Production table First Shift Capacity First and Second Shift Capacity Automation Level Cost to Double Capacity Cost to Raise Automation to 10 Company Found under "Capacity Next Round" Capacity Next Round x 2 (shifts) Increasing capacity is $6 per unit with an adjustment for automation. Increasing automation is per unit of capacity Found under "Automation Next Round" Industry Total the capacity of each product in that segment Total capacity of each product in that segment X 2 Formula is: First Shift Capacity x [$6 + ($4 x automation level)] Example Input: 500 Formula is: First Shift Capacity x [$4 x (10 - automation level)] Example Input: 700 * In the simulation, the input cells are in thousands ('000's), so an input of 1 is actually 1000 units. So, in the example, 500,000 units is inputted as 500 in the cell. This applies to dollar values as well. Incomplete Capacity Analysis Product First Shift Name Capacity Company First & Second Shift Capacity Company Industry Automation Level Cost to Double Capacity Cost to Raise Automation to 10.0 Industry Able 800 0 1600 3 0 0 Production Analysis Fast Track F121332_007 Round: 0 December 31, 2020 Production vs Capacity F121332_007 Andrews Baldwin Chester Digby Erie Ferris 0 100 200 300 400 500 600 700 800 900 1,000 1,100 1.200 Capacity O Production Andrews 1,287 Baldwin 1,287 Chester 1,287 Digby 1,287 Erie 1,287 Ferris 1,287 Units Produced Production Information 2nd Shift Auto Unit & mation Capacity Primary Units Inven Age Size Material Labor Contr. Over Next Next Plant Name Segment Sold tory Revision Date Dec.31 MTBF Coord Coord Price Cost Cost Marg. time Round Round Utiliz. Pfmn Able Low 1,200 87 11/21/2017 3.1 21000 6.4 13.6 $34.00 $16.17 $10.11 20% 63% 3.0 800 161% Baker Low 1,200 87 11/21/2017 3.1 21000 6.4 13.6 $34.00 $16.17 $10.11 20% 63% 3.0 800 161% Cake Low 1,200 87 11/21/2017 3.1 21000 6.4 13.6 $34.00 $16.17 $10.11 20% 63% 3.0 800 161% Daze Low 1,200 87 11/21/2017 3.1 21000 6.4 13.6 $34.00 $16.17 $10.11 20% 63% 3.0 800 161% Eat Low 1,200 87 11/21/2017 3.1 21000 6.4 13.6 $34.00 $16.17 $10.11 20% 63% 3.0 800 161% Fast Low 1,200 87 11/21/2017 3.1 21000 6.4 13.6 $34.00 $16.17 $10.11 20% 63% 3.0 800 161% FOUNDATION FAST TRACK Page 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

A Textbook Of Cost And Management Accounting

Authors: Arora

10th Edition

9789325956209

More Books

Students also viewed these Accounting questions