Hello! Please help fill in both Industry boxes, Costs to Double Capacity, and Cost to...
50.1K
Verified Solution
Link Copied!
Question
Accounting
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 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
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!