Chi Case Study Assignment - Part 2 Problemer Paradise, Inc. makes and its coffee cup tumbler Bach coffee cup hermes 14 pound of plastic Budgeted production of coffee cup tumblers in units for the next three months is as follon October Naber Budgeted production tumblers in mula) 15.000 20,000 The company wants to maintain monthly ending intense of plastic equal to 30 of the following month's budgeted productions. The cost of plastie is 53.00 per pound Instruction Propea direct materials purchases budget for the month of November October Muhe Units to be produced Times Direct matterselspunt Total pounds needed for production Add Died in disc matte Total materials required Le Bists! Direct materials purchase Times Cost Total cost of direct materials purchases Problem. The Parade Inc. bas bacted the following and sales Osarter 20,000 Owarter 1 2 3 4 tinits 75.000 100,000 115.000 125.000 Or Total The finished goods may on hand on December 31, 200 was 15.000 It is the company's policy to maintain a finished goods inwentory at the end of each quartier equal to 15% of the next qumer's anticipated Instructies Prepare a production budget for 2022 Or O Expected une sales Adesired dig finished goods Tocal required finished goods Los lining finished godt Required production units 2. Instructions for Posting (200 to 300 words - Opts): You are in charge of setting the budget for your company which has two different departments You can create your own company or base your example de your company you work for or base your example on the company that you are familiar with. Identity and explain the two different departments in your example for your company. For each department plan your budget with goal that is recurring on a weekly basis. b. Explain how your two departments in your company will coordinate their individual goals to meet the the onerall objectives (goals) of the company as a whole. c. Explain how management and employees will be motivated throughout the two departments to meet the planned objectives (goals) for cach department and for the company as a whole Upload and attach your completed excel file to your posting