Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jul 29, 2024

Your job is to prepare a production schedule (considering the constraints and rules of this case in Chp 19), and to determine the operating budget

Your job is to prepare a production schedule (considering the constraints and rules of this case in Chp 19), and to determine the operating budget for such a plan.

the Simulation Worksheet where you need to indicate the Actual Production Rate and the Actual Demand columns cells (in reality the actual data would be getting filled in each week as time progresses, but you need to fill all 52 weeks with numbers (simply enter 450 into the Actual Production Rate column (each cell) and then copy the Forecast column into the Actual Demand column). Thanks

Simulation Worksheet Beginning Inventory Qtr Wk Lines Scheduled Scheduled Production Expected Ending Forecast Demand Expected Wooks Actual Production of-Supply Rate (cases/hour) Actual Demand (1,000 Cases) Actual Production Actual Ending Inventory Inventory 10 10 10 10 10 10 10 10 10 10 TU 10 10 10 8 8 Overtime Scheduled (hours) 1 1 1 1 1 1 1 1 1 1 1 200.0 237.4 274.8 312.2 349.6 101 387.0 424.4 461.8 499.2 499.2 536.6 574.0 611.4 8 8 8 8 8 1 2 3 4 5 6 1st 7 8 9 10 TU 11 12 12 13 14 14 15 45 16 40 47 17 40 18 40 19 2nd 20 21 22 23 24 25 26 27 29 28 20 29 20 30 31 32 3rd 33 2 34 35 36 37 38 39 40 41 42 43 44 45 648.8 6488 ARE 686.3 670.0 652 653.8 6278 637.6 6242 621.3 605.1 00 588.9 572.6 556.4 540.2 523.9 8 8 8 8 8 8 9 9 9 9 191.3 191.3 191.3 191.3 191.3 191.3 191.3 191.3 191.3 191.3 191.3 191.3 191.3 1520 153.0 1520 153.0 1990 153.0 4 153.0 520 153.0 462 153.0 153.0 ro 153.0 153.0 153.0 153.0 153.0 153.0 192.4 1920 1920 192.4 402 192.4 402 192.4 100 192.4 4022 192.4 402 192.4 100 192.4 2007 192.4 100 192.4 192.4 1967 192.4 2017 192.4 210.4 10.1 210.4 10 210.4 210.4 210.4 210.4 153.8 153.8 153.8 153.8 153.8 153.8 1.o 153.8 133.0 153.8 153.8 153.8 153.8 153.8 153.8 169.2 180 169.2 460 169.2 460 169.2 100 169.2 4602 169.2 160 169.2 100 169.2 169.2 169.2 169.2 169.2 169.2 192.3 192.3 192.3 4022 192.3 1092 192.3 1992 192.3 102 192.3 192.3 192.3 192.3 192.3 192.3 192.3 203.8 200 203.8 200.0 203.8 1 1 1 1 1 1 1 2 2 2 2 2 2 2 2 2 2 2 2 2 1 1 1 1 1 237.4 274.8 312.2 12:2 349.6 42.0 387.0 0.0 2.* 424.4 461.8 401.6 499.2 30.0 536.6 574.0 611.4 648.8 686.3 6700 670.0 653.8 SES aze 637.6 623 621.3 GO 605.1 FO 588.9 572.6 556.4 540.2 523.9 507.7 491.5 475.3 475.3 4754 475.4 AZE 475.5 475.5 AZER 475.6 475.7 4757 475.7 1767 4758 475.8 4720 475.9 475.9 470 * 476.0 110 476.1 476.1 100 482.7 100 489.2 495.7 502.2 508.8 515.3 1.5 1.8 2.0 2.3 2.5 2.8 3.0 3.2 3.4 0.4 3.6 3.7 3.9 4.1 40 4.0 3.9 20 3.8 3.7 2 3.6 3.5 3.4 3.2 3.1 2.9 2.8 2.6 2.5 2.5 2.5 2.5 26 2.5 2.5 25 2.5 2.5 2.4 2.4 2.4 2.4 2.4 2.3 2.4 2.4 2.4 2.5 2.5 2.5 0.0 0.0 0.0 0.0 0.0 0.0 DO 0.0 0.0 0.0 VU 0.0 D. 0.0 0.0 VU 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 00 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 507.7 0.0 0.0 0.0 0.0 0.0 0.0 U. 0.0 V.U 0.0 V. 0.0 0.0 0.0 V. 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 00 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 9 9 9 9 9 9 491.5 475.3 475.3 475.4 475.5 Az 475.5 475.6 Az 475.7 ze 475.7 475.8 475.9 475.9 476.0 0 476.1 476.1 482.7 1001 489.2 495.7 502.2 508.8 9 9 9 11 11 11 11 11 203.8 203.8 11 203.8 192.5 9 9 O O O O C 9 9 Oo 9 9 32 3rd 33 34 35 36 37 38 39 40 41 42 43 44 45 4th 46 47 48 49 50 51 52 2 2 2 2 2 2 2 2 1 1 1 1 3.3 475.6 475.7 475.7 475.8 475.9 475.9 476.0 476.1 476.1 482.7 489.2 495.7 502.2 508.8 515.3 521.8 528.4 534.9 541.4 547.9 554.5 192.4 192.4 192.4 192.4 192.4 192.4 192.4 192.4 192.4 210.4 210.4 210.4 210.4 210.4 210.4 210.4 210.4 210.4 210.4 210.4 210.4 210.4 9 9 11 11 11 11 11 11 11 11 11 11 11 11 11 2.3 2.5 2.5 2.4 2.4 2.4 2.4 2.4 2.3 2.4 2.4 2.4 2.5 2.5 2.5 2.6 2.7 2.8 475.7 475.7 475.8 475.9 475.9 476.0 476.1 476.1 482.7 489.2 495.7 502.2 508.8 515.3 521.8 528.4 534.9 541.4 547.9 554.5 561.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1 192.3 192.3 192.3 192.3 192.3 192.3 192.3 192.3 203.8 203.8 203.8 203.8 203.8 203.8 203.8 203.8 203.8 203.8 203.8 203.8 203.8 169.2 169.2 169.2 169.2 169.2 169.2 169.2 169.2 169.2 169.2 169.2 169.2 169.2 1 1 1 1 1 1 1 1 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 2.9 3.0 3.2 3.3 5th Simulation Worksheet Beginning Inventory Qtr Wk Lines Scheduled Scheduled Production Expected Ending Forecast Demand Expected Wooks Actual Production of-Supply Rate (cases/hour) Actual Demand (1,000 Cases) Actual Production Actual Ending Inventory Inventory 10 10 10 10 10 10 10 10 10 10 TU 10 10 10 8 8 Overtime Scheduled (hours) 1 1 1 1 1 1 1 1 1 1 1 200.0 237.4 274.8 312.2 349.6 101 387.0 424.4 461.8 499.2 499.2 536.6 574.0 611.4 8 8 8 8 8 1 2 3 4 5 6 1st 7 8 9 10 TU 11 12 12 13 14 14 15 45 16 40 47 17 40 18 40 19 2nd 20 21 22 23 24 25 26 27 29 28 20 29 20 30 31 32 3rd 33 2 34 35 36 37 38 39 40 41 42 43 44 45 648.8 6488 ARE 686.3 670.0 652 653.8 6278 637.6 6242 621.3 605.1 00 588.9 572.6 556.4 540.2 523.9 8 8 8 8 8 8 9 9 9 9 191.3 191.3 191.3 191.3 191.3 191.3 191.3 191.3 191.3 191.3 191.3 191.3 191.3 1520 153.0 1520 153.0 1990 153.0 4 153.0 520 153.0 462 153.0 153.0 ro 153.0 153.0 153.0 153.0 153.0 153.0 192.4 1920 1920 192.4 402 192.4 402 192.4 100 192.4 4022 192.4 402 192.4 100 192.4 2007 192.4 100 192.4 192.4 1967 192.4 2017 192.4 210.4 10.1 210.4 10 210.4 210.4 210.4 210.4 153.8 153.8 153.8 153.8 153.8 153.8 1.o 153.8 133.0 153.8 153.8 153.8 153.8 153.8 153.8 169.2 180 169.2 460 169.2 460 169.2 100 169.2 4602 169.2 160 169.2 100 169.2 169.2 169.2 169.2 169.2 169.2 192.3 192.3 192.3 4022 192.3 1092 192.3 1992 192.3 102 192.3 192.3 192.3 192.3 192.3 192.3 192.3 203.8 200 203.8 200.0 203.8 1 1 1 1 1 1 1 2 2 2 2 2 2 2 2 2 2 2 2 2 1 1 1 1 1 237.4 274.8 312.2 12:2 349.6 42.0 387.0 0.0 2. 424.4 461.8 401.6 499.2 30.0 536.6 574.0 611.4 648.8 686.3 6700 670.0 653.8 SES aze 637.6 623 621.3 GO 605.1 FO 588.9 572.6 556.4 540.2 523.9 507.7 491.5 475.3 475.3 4754 475.4 AZE 475.5 475.5 AZER 475.6 475.7 4757 475.7 1767 4758 475.8 4720 475.9 475.9 470 * 476.0 110 476.1 476.1 100 482.7 100 489.2 495.7 502.2 508.8 515.3 1.5 1.8 2.0 2.3 2.5 2.8 3.0 3.2 3.4 0.4 3.6 3.7 3.9 4.1 40 4.0 3.9 20 3.8 3.7 2 3.6 3.5 3.4 3.2 3.1 2.9 2.8 2.6 2.5 2.5 2.5 2.5 26 2.5 2.5 25 2.5 2.5 2.4 2.4 2.4 2.4 2.4 2.3 2.4 2.4 2.4 2.5 2.5 2.5 0.0 0.0 0.0 0.0 0.0 0.0 DO 0.0 0.0 0.0 VU 0.0 D. 0.0 0.0 VU 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 00 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 507.7 0.0 0.0 0.0 0.0 0.0 0.0 U. 0.0 V.U 0.0 V. 0.0 0.0 0.0 V. 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 00 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 9 9 9 9 9 9 491.5 475.3 475.3 475.4 475.5 Az 475.5 475.6 Az 475.7 ze 475.7 475.8 475.9 475.9 476.0 *0 476.1 476.1 482.7 1001 489.2 495.7 502.2 508.8 9 9 9 11 11 11 11 11 203.8 203.8 11 203.8 192.5 9 9 O O O O C 9 9 Oo 9 9 32 3rd 33 34 35 36 37 38 39 40 41 42 43 44 45 4th 46 47 48 49 50 51 52 2 2 2 2 2 2 2 2 1 1 1 1 3.3 475.6 475.7 475.7 475.8 475.9 475.9 476.0 476.1 476.1 482.7 489.2 495.7 502.2 508.8 515.3 521.8 528.4 534.9 541.4 547.9 554.5 192.4 192.4 192.4 192.4 192.4 192.4 192.4 192.4 192.4 210.4 210.4 210.4 210.4 210.4 210.4 210.4 210.4 210.4 210.4 210.4 210.4 210.4 9 9 11 11 11 11 11 11 11 11 11 11 11 11 11 2.3 2.5 2.5 2.4 2.4 2.4 2.4 2.4 2.3 2.4 2.4 2.4 2.5 2.5 2.5 2.6 2.7 2.8 475.7 475.7 475.8 475.9 475.9 476.0 476.1 476.1 482.7 489.2 495.7 502.2 508.8 515.3 521.8 528.4 534.9 541.4 547.9 554.5 561.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1 192.3 192.3 192.3 192.3 192.3 192.3 192.3 192.3 203.8 203.8 203.8 203.8 203.8 203.8 203.8 203.8 203.8 203.8 203.8 203.8 203.8 169.2 169.2 169.2 169.2 169.2 169.2 169.2 169.2 169.2 169.2 169.2 169.2 169.2 1 1 1 1 1 1 1 1 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 2.9 3.0 3.2 3.3 5th

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Get Instant Access to Expert-Tailored Solutions

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

Step: 2

Step: 3

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

Financial Accounting For Decision Makers

Authors: Peter Atrill, Eddie McLaney

7th Edition

027378563X, 9780273785637

More Books

Students also viewed these Accounting questions

Question

★★★★★

Consider the following binomial option pricing problem involving an American call. This call has two periods to go before expiring. Its stock price is 30, and its exercise price is 25. The risk-free...

Answered: 1 week ago

Question

★★★★★

=+18. Traffic delays. The Texas Transportation Institute (tti.tamu.edu) studies traffic delays. They estimate that in the year 2011, 498 urban areas experienced 5.5 billion vehicle hours of delay,...

Answered: 1 week ago

Question

★★★★★

Kinga Doll Company manufactures eight versions of its popular girl doll, Shari. The company operates on a 40-hour work week. The eight versions differ in doll skin, hair, and eye color, enabling most...

Answered: 1 week ago

Question

★★★★★

3 The following information is available for Market, Inc. and Supply, Inc. at December 31: Accounts receivable Allovance fer doubtful accounts $ 59,200 2,648 646,960 15 $ 79,600 17,100 Required a....

Answered: 1 week ago

Question

★★★★★

\fthat X-0 why. x - 2+ 5. If lim f(x) = 8 but lim f(x) does not exist, what can you X-2 say about lim f(x)? im- x-2Ullta asymptote aty Examples: Construct examples of the thing(s) described in the...

Answered: 1 week ago

Question

★★★★★

we look at how companies use CRM, SCM, and ERP to gain a competitive advantage and run more efficiently. Find an industry/business or company currently using one of those technologies (CRM, SCM,...

Answered: 1 week ago

Question

★★★★★

1. What are the practices that Xerox used in its TQM implementation? Discuss. 2. What are some barriers that you think Xerox has faced during TQM implementation? Relate them. 3. Does TQM...

Answered: 1 week ago

Question

★★★★★

An automobile manufacturer based in Lexington, Kentucky, wants to move production jobs from Japan to Mexico so that it can be more responsive to changing demands in its North American markets. Which...

Answered: 1 week ago

Question

★★★★★

Two weeks after they were told about the city's proposal to demolish the neighborhood playground and build a parking lot, Diana approached Tony as they were heading to another neighborhood...

Answered: 1 week ago

Question

★★★★★

#3. Test to see if there is a significant difference between the age of the participant and the age of the partner. Use a paired-sample t-test and an alpha level of 1%. How would you interpret the...

Answered: 1 week ago

Question

★★★★★

=+Differentiate between social media roles

Answered: 1 week ago

Question

★★★★★

=+2. You are applying for an internship to work with the brand Cinnabon. Along with creating a rsum and cover letter, the company is asking you to demonstrate who you are as a brand. Create a visual...

Answered: 1 week ago

Question

★★★★★

=+4. What are some personal associations you have now, and where do you want to go? Evaluate at least a few of the competitors in your network and what they are doing, and write down some action...

Answered: 1 week ago

Previous Question Next Question