On the last day of class you will be provided a sales forecast, a master production schedule, and actual sales in period of 3Js Corporation. The finance department is asking why the actual inventory numbers are different from the inventory projections provided by the supply chain department earlier in the year. Write a 300.500 word email explaining what happened and why inventory for the accounting period is different than what was originally projected.

To: Arens, Brodie Subject: June Inventory Variance Brodie, I hope this email finds you well and you that are getting ready to enjoy the upcoming July Fourth holiday. I was looking at our month- end inventory balances for the month of June and they are far different than the projection numbers that you gave me last month. We closed the month with $10,420 worth of inventory when we had originally communicated that we would be much higher at $18,821. That is a variance of approximately 45% which is fairly large and will require an explanation to leadership. Can you provide quick summary of what happened in June and why we have such a large variance? me a Is it possible to get it by end of business tomorrow before we all leave for the holiday? Thanks so much! Kyle Data is in Cartons Actual Actual Actual Actual Actual Actual Apr June May Feb Type Jan Mar Label Strawberry Jam 3Js 684 616 631 384 2013 Forecast 566 671 Marran Markets Raspberry Jelly 800 571 379 425 2013 Forecast 744 737 Kerry's Marts Peach Jam 236 117 84 78 2013 Forecast 167 146 Dom's Food Stores Blueberry Jam 88 108 139 80 100 2013 Forecast Apple/Mint Jelly AAA Grocers 25 88 146 63 110 73 2013 Forecast 99 20 Marra 201 Deta is in Cartons Actual Actual Actual Actual Actual Dec. Year Total Nov Oct Label Sept Aug July Strawberry Jam Jan Feb ar Apr June 'st ay 3Js 7,604 699 607 683 2013 Forecast 733 701 566 384 691 671 622 631 616 Marran Markets 6,208 Raspberry Jelly 470 476 538 2013 Forecast 452 458 460 744 497 737 425 379 571 Kerry's Marts 2013 Forecast 1,462 Peach Jam 111 132 134 125 119 116 134 146 78 84 117 167 Dom's Food Stores Blueberry Jam 2013 Forecast 1,308 102 118 114 103 109 113 122 139 108 100 99 80 AAA Grocers Apple/Mint Jelly 1,075 85 89 78 84 85 83 2013 Forecast 146 88 73 63 110 93 un m 3J's June 2013 Master Production Schedule Data is in Certons Dec-134 1,048 Nov-135 Oct-13 687 683 900 905 Sep-11 Aug-13 322 70 825 445 2.8 Label 3/s 3Us 3Js 3/s 3Us 3/s 905 Jul-13 Jam/Jelly Std Cost (Carton Jun-13 Flayor Key Figure 445 265 GO7 Jam Jam Jam Strawberry Deginning inventory Strawberry Forecast Strawberry Production Strawberry Ending Inventory Strawberry weeks of Supply (caloulated) Strawberry weeks of Supply (Target) Strawberry inventory Dollars Flavor Raspberry Beginning inventory Raspberry Forecast Raspberry Production Raspberry Ending inventory Raspberry Weeks of Supply (calculated) Raspberry Weeks of Supply (Target) Raspberry 134 733 675 691 750 750 622 750 975 1024 1,048 687 6.5 322 6 262 lam 5.8 44 6 6 19 16 E lam 6 $19.475 6 $29,695 Nov 13 440 $29,006 $25,639 Jam $12.614 $9.111 Dec-13 $7,436 $28.34 Oct 13 528 538 Jam Sep-13 536 458 450 639 470 Aug-13 Aul-13 249 460 Jun-13 Key Figure Std Cost (Cartonk Label Jam/lely Jelly Jelly Jelly Jelly Jely 539 76 497 476 Marran Markets Marran Markets Marran Markets Marran Markets Marran Markets Marran Markets Marran Markets Label Kerry's Marts Kerry's Marts Kerry's Marts Kerry's Marts Kerry's Marts Kerry's Marts Kerry's Marts Label Doms Food Stores Doms Food Stores Doms Food Stores Doms Food Stores Doms Food Stores Doms Food Stores Doms Food Stores Label AAA Grocers AAA Grocers AAA Grocers 457 525 694 675 639 450 450 750 670 440 536 4.6 528 539 5.9 249 S.7 19 4.5 4.7 2.3 6 6 $21,1796 Dec-13 164 $19,499 $13420 Oct-13 Jelly $16,112) $16,363 Aug 13 $16,437 $7.592 Jun-13 Nov-13 Inventory Dellars Key Figure San.52 Jely Jam/Jely Sep-13 Jul:13 Std Cost (Carton) 146 132 150 164 121 125 Flavor 104 73 40 98 134 111 150 203 Peach Peach Beginning Inventorys Forecast Production Ending Inventory Weeks of Supply (calculated Weeks of Supply (Target)y Imventory Dolars Key Figure 134 Jam 119 150 104 116 150 150 Jam 150 75 146 Peach 73 121 Jam 7.C 6.25 5.0 Peach 4.1 Jam 3.4 2.4 1.3 6 6 6 Peach lam $4,405 $5,453 $3,237 $3.922 $2.793 Peach Peach Jam $1.967 $1,061 $2686 Dec-13 Nov-13 Oct-13 Sep-13 Jam Aug-13 Jul-13 Jun-13 Std Cost (Carton) 190 116 158 122 Jam/lely Flavor 5 55 4: Blueberry Beginning Inventory Blueberry Forecast Blueberry Production Blueberry Ending Inventory Blueberry Weeks of Supply (calculated) Blueberry Weeks of Supply (Target) Blueberry Inventory Dollars 102 118 103 114 109 Jam 113 122 150 110 150 110 220 Jam 75 110 198 190 158 122 116 Jam 43 7.5 78 6.0 4.6 4.3 Jam 0.2 17 6 6 6 Jam 55,741 $5.518 $4,581 Oct-13 105 $3,548 $3.356 $133 Jam $1.245 $29 01 Std Cost (Carton) Dec-13 Nov-13 Sep-13 Jam Aug-13 Jul-13 Jun-13 163 149 Key Figure 77 47 Flavor Jam/lelly 57 85 75 39 Apple/Mint Beginning Inventorys Apple/Mint Forecast Apple/Mint Production Apple/Mint Ending inventory Apple/Mint Weeks of Supply (calculated) Apple/Mint Weeks of Supply (Target) Apple/Mint inventory Dollars 89 85 93 78 84 Jelly 83 75 75 150 110 110 Jelly 100 139 149 105 163 7.9 73 3.5 jelly 47 57 6.6 74 5.0 6 $2.770 AAA Grocers AAA Grocers AAA Grocers AAA Grocersi Jelly Jelly 2.3 2.9 6 6 6 6 $3,658 $3.922 $4,284 $1,915 Jely $1,224 $1,487 $26 32 Jelly 20 24 24 23 24 23 Grand Total Batches/Month $65,037 $63,038 $51,845 $45,141 $37,042 $28.873 $18,821 Total Inventory Dollars 3/'s Inventory June 2013 Actual Production Data Data is in Cartons Actual Jun-13 Std Cost (Carton) Label Jam/Jelly Flavor Key Figure 134 3Js 3Js 3Js Strawberry Beginning Inventory Strawberry Forecast Strawberry Production Strawberry Ending Inventory Strawberry Weeks of Supply (calculated) Strawberry Weeks of Supply (Target) Strawberry Inventory Dollars Jam 684 Jam 683 Jam 133 3Js 3Js 31s 3Js Jam 0.8 Jam Jam $3,769 $28.34 Jam Jun-13 Std Cost (Carton) Label Jam/Jelly Flavor Key Figure 76 Marran Markets Marran Markets Raspberry Beginning Inventory Jelly 800 Raspberry Forecast Raspberry Production Raspberry Ending Inventory Raspberry Weeks of Supply (calculated) Jelly 750 Marran Markets Jelly 26 Marran Markets Jelly 0.2 Marran Markets Jelly Jelly 6 Weeks of Supply (Target) Raspberry Marran Markets $794 $30.52 Raspberry Inventory Dollars Marran Markets Jelly Jun-13 98 Std Cost (Carton) Key Figure Flavor Label Jam/Jelly Beginning Inventory Forecast Peach Kerry's Marts Kerry's Marts Jam 236 Peach Jam 150 Production Peach Kerry's Marts Kerry's Marts Kerry's Marts Kerry's Marts Kerry's Marts Label Doms Food Stores Jam 12 Ending Inventory Weeks of Supply (calculated) Weeks of Supply (Target) Peach Jam 0.4 Peach Jam 6 Peach Jam $322 $26.86 Inventory Dollars Peach Jam Jun-13 Std Cost (Carton) Key Figure Flavor Jam/Jelly 55 Blueberry Beginning Inventory Blueberry Forecast Production Jam 88 Doms Food Stores Jam 75 Blueberry Blueberry Ending Inventory Blueberry Weeks of Supply (calculated) Blueberry Weeks of Supply (Target) Blueberry Jam Doms Food Stores 42 Jam Doms FoodStores 1.6 Jam Doms Food Stores 6 Doms Food Stores Jam $1,218 $29.01 Inventory Dollars Key Figure Jam Doms Food Stores Jun-13 Std Cost (Carton) Flavor Jam/Jelly Label Apple/Mint Beginning Inventory Apple/Mint Forecast Apple/Mint Production Apple/Mint Ending Inventory Apple/Mint Weeks of Supply (calculated) Apple/Mint Weeks of Supply (Target) Apple/Mint Inventory Dollars Jelly AAA Grocers 25 Jelly AAA Grocers 150 Jelly AAA Grocers 164 Jelly AAA Grocers 8.4 Jelly AAA Grocers 6 Jelly AAA Grocers $26.32 $4,316 Jelly AAA Grocers 24 Grand Total Batches/Month $10,420 Total Inventory Dollars 3J's Inventory 399 From: Thompson, Kyle Sent: Tuesday July 2, 2019 4:49 PM To: Arens, Brodie Subject: June Inventory Variance Brodie, I hope this email finds you well and you that are getting ready to enjoy the upcoming July Fourth holiday. I was looking at our month- end inventory balances for the month of June and they are far different than the projection numbers that you gave me last month. We closed the month with $10,420 worth of inventory when we had originally communicated that we would be much higher at $18,821. That is a variance of approximately 45% which is fairly large and will require an explanation to leadership. Can you provide me a quick summary of what happened in June and why we have such a large variance? Is it possible to get it by end of business tomorrow before we all leave for the holiday? Thanks so much! Kyle