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

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

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 Accounting Questions!