I Updated the pictures since sombedoy said they arent really visible. I posted a

Question

I Updated the pictures since sombedoy said they arent really visible. I posted a new question. ..Hey I need this done before 11:59. I’ll make sure to rate and like answers. I have some done already need this ASAP Pleaseeee.

Insert Page Layout Formulas Data Review View Cut Arial Copy Home Number O A- A aste Format ACCT 201-05-SPRING 2018 BAFFOUR ADJE BIG DOG, ING Sales price per housing unt April sales forecast On unts) May saies forecast (i unvts) June sales fonecast (n unts July sales forecast (in units) Auguat sales forecast on unis) Raw material used per house ( of board feet) 1Raw material 2 Direct labor hours per houning unit 3 Direct lsbor 4 Wariable manufacturing overhead per DLH cost per boand foot $22.00 $4 25 5 Flxed manufacturing overhead per month 6 Ending material inventory (S of next months production needs) 17 Endng Finished Goods nventory r% net months sales) Variable selling expense per housing unit Fixed seling expense per month ncome tax Sales Budget 4 Sales (in units) Sales price per housing unit Sales revenue $3,300,000.00 Add Desired ending inventory Less Projected beginning inventory Plasned production in uni 925 1499 38 Plenned Production (n unia) aw Material requined for production (board seet) 40 Add Desired Ending inventory of Raw Material, in board feet Total Requirements 42 Less 43 Planned Purchases of Raw Material (board fee Beginning Inventory of Raw Material, in board feet Cost per board foo 45 Planned Purchases of Raw Material (dollas) 358,37 50 449,312 50 5457 205.00 Sheett Sheets Sheet2 Sheot3+ 901 esc

Explanation / Answer

BIG DOG INC Manufacturing Cost budget April May June Total Raw Materials:    Total raw material required for production 73500 90500 113500 277500     Cost of raw material per board foot $3.50 $3.50 $3.50 $3.50 Budgeted cost of raw material used in production 257250 316750 397250 971250 Direct Labor:     Direct labor hours per housing unit 3.50 3.50 3.50 3.50     Total direct labor hours required 12862.5 15837.5 19862.5 48562.5     Labor rate per hour $22.00 $22.00 $22.00 $22.00 Budgeted labor cost required for porduction 282975 348425 436975 1068375 Manufacturing overhead:     Variable 54666 67309 84416 206391     Fixed 175000 175000 175000 525000 Total Manufacturing Costs 769891 907484 1093641 2771016 Selling Expenses budget April May June Total Variable selling expense 332500 380000 522500 1235000 Fixed selling expense 130000 130000 130000 390000 Planned total selling expense 462500 510000 652500 1625000 BIG DOG INC Income statement for the second quarter ended 6/30/2018 (Contribution Margin Format) Sales 7150000 Variable costs:    Direct material 971250    Direct labor 1068375    Variable manufacturing overheads 206391    Variable selling expenses 1235000 Total variable costs 3481016 Contribution margin 3668984 Fixed expenses:    Manufacturing overhead 525000    Selling expenses 390000 Total fixed expenses 915000 Net income before taxes 2753984 Income tax expense 963895 Net income 1790090 BIG DOG INC Income statement for the second quarter ended 6/30/2018 Sales 7150000 Cost of goods sold 2596267 Gross profit 4553733 Operating costs 1625000 Income before taxes 2928733 Income taxes 1025057 Net income 1903676 Direct material cost 971250 Direct labor cost 1068375 Variable manufacturing overhead 206391 Fixed manufacturing overhead 525000 Total manufacturing cost 2771016 Total production -- units 13875 Product cost per set 200 Sales -- no.of sets 13000 Cost of goods sold 2596267

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

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