Hi this is very short and easiets work, Please do it in excel and show me the fo

Question

Hi this is very short and easiets work, Please do it in excel and show me the formulas. Please do not make any mistake Please I need fast help in this. I need in 2 hours

A14 Budgeted Direct Materials Cost Per UNIT 1 Master Budget Data: 3 List Your Product Name Here ENTER YOUR INDIVIDUAL CASE NUMBER HERE 6 (THIS IS LOCATED IN YOUR GRADEBOOK) First Name Last Name 9 Enter Your Name Here 10 11 BASE DATA 12 Foundation Data for Solving questions 1, 2 and 3: 13 14 15 15.00 10.00 5.00 17 18 Budgeted Manufacturing Overhead Per UNIT 19 20 21 IN ADDITION TO ABOVE USE THE FOLLOWING 23 24 This is Next Year's Budgeted Data for XYZ 25 26 Budgeted Sales Price Per UNIT 27 20.00

Explanation / Answer

1 Units to be produced=Target Ending finished goods inventory+Budgeted sales-Target Beginning finished goods inventory=2500+15000-1850=15650 units Formula using excel c30+c28-c32 2 $ amount budgeted for direct material purchase=(Ending direct materials inventory+Units to be produced-Beginning direct materials inventory)*Budgeted direct material cost per unit $ amount budgeted for direct material purchase=(8500+15650-6500)*15=264750 Formula using excel Step:1 c34+c28-c36 Step:2 Multiply above cell by 15 3 Budgeted reveue=Budgeted sales*Budgeted sales price per unit=15000*20=$ 300000 Formula using excel c28*c26 4 Budgeted cash collections for the month of may Formula using excel May month sales collected 15000*50%=7500 e59*b63 April month sales collected 7500*30%=2250 e58*b64 March month sales collected 4000*15%=600 c60*b65 Total 10350 sum(these 3 cells)

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.