Question: Please solve only 3 question that I can't solve is sales budget, production budget, and direct material. please give answer in excel and give the

Please solve only 3 question that I can't solve is sales budget, production budget, and direct material. please give answer in excel and give the formula so that I can undetstand. Thank you
PT Joy is a company that produces paint. Sales projections and initial and final inventory data for 2020 are as follows: Unit Price 1 19,000 10,000 1,000 Quarter 2 3 4 17,500 19,680 20,700 10,000 10,000 10,000 1,340 600 1,120 Year's 76,880 10,000 1,000 Beg Inv End. Iny 1,340 600 1,120 1,000 1,000 Each can of paint requires 4 liters of thinner at a price of IDR 300/liter, where the ending inventory is 25% of the production need and the beginning inventory is 2 times the ending inventory. Each can of paint takes 20 minutes to produce, with a labor wage of IDR 50/minute. The variable overhead rate is IDR 750/minute/ direct labor. Fixed overhead budgeted IDR20,000,000 per year. Required: Make a sales budget, production budget, direct material budget, direct labor budget, overhead budget for 2020 and give your explanation about the result
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
