Question: (b) Given that the plan was to maintain 5 days of supply in inventory, interpret the spreadsheet and explain the primary reason(s) why inventory is

(b) Given that the plan was to maintain 5 days of

(b) Given that the plan was to maintain 5 days of supply in inventory, interpret the spreadsheet and explain the primary reason(s) why inventory is off target at the end of December. (c) What action(s) would you consider to bring inventory levels back toward target in January? Maple Co. SOP Spreadsheet History Plan Oct Nov Dec Jan Sales 800 850 900 900 Plan (Units) Actual (Units) 812 835 909 Diff month 12 -15 9 Diff. cumulative -3 6 800 860 890 24 30 31 Operations Plan (units) Plan (employees) Number working day/mo. Actual (Units) Diff. month 22 19 19 20 795 803 857 -5 -57 -33 Diff. cumulative -62 -95 Inventory Plan (in units) 225 235 225 Actual (in units) 208 176 124 Days of Supply 4.7 3.7 2.8

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Problem 2 Maple Co . SOP Historical Data Maple Company plans to maintain 5 days of supply in inventory, but actual inventory is off target at the end of the year. ( a ) Complete the history portion...

Could somebody help me with this? What did I do wrong? I have included all instructions and numbers. My word is shown in the Excel pictures. ^This is my Chase plan My level-utilization and mixed plan...

could you please help me with this? will rate! References: Keep in mind that pure chase strategies do not use overtime. However, in a level- utilizationstrategy the staffing is kept level, but...

Use the decomposition technique to forecast the four quarters of 2010. 5. Sales data for two years are as follows. Data are aggregated with two months of sales in each "period." a. Plot the data. b....

Digitex Corporation Beginning in the late 1990s, Digitex Corporation began a policy of doing business "using time as a prime competitive weapon." Specifically, this involved collapsing time from...

Beginning in the late 1990s, Digitex Corporation began a policy of doing business using time as a prime competitive weapon. Specifically, this involved collapsing time from product time-to-market as...

Digitex Corporation Beginning in the late 1990s, Digitex Corporation began a policy of doing business using time as a prime competitive weapon. Specifically, this involved collapsing time from...

Rom its origins in 1914 as a small business, Innova Ltd has grown into one of Australia's largest listed companies. Some of its acquisitions include the home improvement retailer Handyman Warehouse...

Explain how the ten management decisions of operations management and justify how you will apply them at Ushaka Marine World.

Byrde Company purchased a truck. The seller asked for $ 1 3 , 2 0 0 , but Byrde paid only $ 1 2 , 2 0 0 after negotiation. The owner of Byrde Company believes he got a great deal and the truck is...

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...