Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Bird Paradise makes backyard birdfeeders. The company sells the birdfeeders to home improvement stores for $ 12 per birdfeeder. Each birdfeeder requires 3.0 board feet

Bird Paradise makes backyard birdfeeders. The company sells the birdfeeders to home improvement stores for $ 12 per birdfeeder. Each birdfeeder requires 3.0 board feet of wood, which the company obtains at a cost of $ 6 per board foot. The company would like to maintain an ending stock of wood equal to 20 % of the next month's production requirements.

ignore the numbers in the picture !! thank u

image text in transcribed

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

The company would also like to maintain an ending stock of finished birdfeeders equal to 15% of the next month's sales. Sales data for the company is as follows: Data Table Units October actual sales (prior year) 90,000 November actual sales (prior year) . . . . 86,000 December actual sales (prior year) . . . . 74,000 January projected sales February projected sales projected sales April projected sales 104,000 . . . . Print Done Requirement 1. Prepare the sales budget for the first three months of the year, as well as a summary budget for the quarter, including a separate section that details the type of sales made (cash versus credit.) Bird Paradise Sales Budget For the Quarter Ended March 31 Month March Qter January February Unit sales Multiply by: Sales price per unit Total sales revenue Cash sales Credit sales Total sales revenue Requirement 2. Prepare the production budget for the first three months of the year, as well as a summary budget for the quarter Backyard Warehouse Production Budget For the Quarter Ended March 31 Month February Quarter January March 93,000 79,000 92,000 264,000 Unit sales 23,250 23,000 26,000 26,000 Plus: Desired ending inventory 102,250 116,000 118,000 290,000 Total needed 23,250 19,750 23,000 19,750 Less: Beginning inventory 92,750 95,000 82,500 270,250 Units to produce Requirement 3. Prepare the direct materials purchases budget for the first three months of the year, as well as a summary budget for the quarter. Assume the company needs 115,000 board feet of wood for production in April. (Round your answers to the nearest whole dollar.) Backyard Warehouse Direct Materials Budget For the Quarter Ended March 31 Month February March Quarter January 92,750 95,000 270,250 82,500 Units to be produced 2.0 2.0 2.0 2.0 Multiply by: Quantity (board feet) of DM needed per unit 165,000 185,500 190,000 540,500 Quantity (board feet) needed for production 18,550 19,000 11,500 11,500 Plus: Desired ending inventory of DM 183,550 204,500 201,500 552,000 Total quantity (board feet) needed 16,500 18,550 16,500 19,000 Less: Beginning inventory of DM 167,050 185,950182,500 535,500 Quantity (board feet) to purchase 5.00 $ 5.00 $ 5.00$ 5.00 Multiply by: Cost per board foot Requirement 4. Prepare the cash collections budget for January, February, and March, as well as a summary for the first quarter. (Round your answers to the nearest whole dollar.) sales budget pre eview Backyard Warehouse Cash Collections Budget For the Quarter Ended March 31 Month Quarter January Februa March $ 150,100 $ 176,700 $ 174,800$ 501,600 Cash sales in current month Collections on credit sales 1,108,080 1,080,720 1,272,240 3,461,040 80% of credit sales made one month ago 138,510 35,090 422,370 148,770 10% of credit sales made two months ago 55,404 59,508 176,472 61,560 4% of credit sales made three months ago $1,468,510 $ 1,455,438 $ 1,637,534 $ 4,561,482 Total cash collections Requirement 5. Prepare the cash payments budget for direct materials purchases for the months of January, February, and March, as well as a summary for the first quarter. red in Requireme aterials budget eview Backyard Warehouse Cash Payments for Direct Materials Budget For the Quarter Ended March 31 Month January February March Quarter $ 501,150 S 557,850 $ 547,500 $ 1,606,500 60% of current month DM purchases 914,000 208,000 334,100 371,900 40% of last month's DM purchases $ 709,150 $ 891,950 $ 919,400 $ 2,520,500 Total cash payments The company would also like to maintain an ending stock of finished birdfeeders equal to 15% of the next month's sales. Sales data for the company is as follows: Data Table Units October actual sales (prior year) 90,000 November actual sales (prior year) . . . . 86,000 December actual sales (prior year) . . . . 74,000 January projected sales February projected sales projected sales April projected sales 104,000 . . . . Print Done Requirement 1. Prepare the sales budget for the first three months of the year, as well as a summary budget for the quarter, including a separate section that details the type of sales made (cash versus credit.) Bird Paradise Sales Budget For the Quarter Ended March 31 Month March Qter January February Unit sales Multiply by: Sales price per unit Total sales revenue Cash sales Credit sales Total sales revenue Requirement 2. Prepare the production budget for the first three months of the year, as well as a summary budget for the quarter Backyard Warehouse Production Budget For the Quarter Ended March 31 Month February Quarter January March 93,000 79,000 92,000 264,000 Unit sales 23,250 23,000 26,000 26,000 Plus: Desired ending inventory 102,250 116,000 118,000 290,000 Total needed 23,250 19,750 23,000 19,750 Less: Beginning inventory 92,750 95,000 82,500 270,250 Units to produce Requirement 3. Prepare the direct materials purchases budget for the first three months of the year, as well as a summary budget for the quarter. Assume the company needs 115,000 board feet of wood for production in April. (Round your answers to the nearest whole dollar.) Backyard Warehouse Direct Materials Budget For the Quarter Ended March 31 Month February March Quarter January 92,750 95,000 270,250 82,500 Units to be produced 2.0 2.0 2.0 2.0 Multiply by: Quantity (board feet) of DM needed per unit 165,000 185,500 190,000 540,500 Quantity (board feet) needed for production 18,550 19,000 11,500 11,500 Plus: Desired ending inventory of DM 183,550 204,500 201,500 552,000 Total quantity (board feet) needed 16,500 18,550 16,500 19,000 Less: Beginning inventory of DM 167,050 185,950182,500 535,500 Quantity (board feet) to purchase 5.00 $ 5.00 $ 5.00$ 5.00 Multiply by: Cost per board foot Requirement 4. Prepare the cash collections budget for January, February, and March, as well as a summary for the first quarter. (Round your answers to the nearest whole dollar.) sales budget pre eview Backyard Warehouse Cash Collections Budget For the Quarter Ended March 31 Month Quarter January Februa March $ 150,100 $ 176,700 $ 174,800$ 501,600 Cash sales in current month Collections on credit sales 1,108,080 1,080,720 1,272,240 3,461,040 80% of credit sales made one month ago 138,510 35,090 422,370 148,770 10% of credit sales made two months ago 55,404 59,508 176,472 61,560 4% of credit sales made three months ago $1,468,510 $ 1,455,438 $ 1,637,534 $ 4,561,482 Total cash collections Requirement 5. Prepare the cash payments budget for direct materials purchases for the months of January, February, and March, as well as a summary for the first quarter. red in Requireme aterials budget eview Backyard Warehouse Cash Payments for Direct Materials Budget For the Quarter Ended March 31 Month January February March Quarter $ 501,150 S 557,850 $ 547,500 $ 1,606,500 60% of current month DM purchases 914,000 208,000 334,100 371,900 40% of last month's DM purchases $ 709,150 $ 891,950 $ 919,400 $ 2,520,500 Total cash payments

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting For Management

Authors: Paresh Shah

2nd Edition

0198077033, 978-0198077039

More Books

Students also viewed these Accounting questions

Question

Explain why a safety net can save the life of a circus performer.

Answered: 1 week ago