make sure to do all $5$ requirments Question list

Question $1$

Question $2$

Question $3$

Question $4$

Question $5$

Question $6$

Question $7$

More info

In any given month, $20\%$ of the total sales are cash sales, while the

remainder are credit sales.

The company's collection history indicates that $80\%$ of credit sales is

collected in the month after the sale, $10\%$ is collected two months

after the sale, $4\%$ is collected three months after the sale, and the

remaining $6\%$ is never collected.

Assume that the total cost of direct materials purchases in December

was $$510,000.$ The company pays $40\%$ of its direct materials

purchases in the month of purchase, and pays the remaining $60\%$ in

the month after purchase.

Backyard Paradise makes backyard birdhouses. The company sells the birdhouses to home improvement stores for $$17$

per birdhouse. Each birdhouse requires $1\mathrm{.}0$ board feet of wood, which the company obtains at a cost of $$2$ per board foot.

The company would like to maintain an ending stock of wood equal to $10\%$ of the next month's production requirements.

The company would also like to maintain an ending stock of finished birdhouses equal to $15\%$ of the next month's

sales. Sales data for the company is as follows:

$($Click the icon to view the sales data.$)$

$($Click the icon to view additional data.$)$

Read the requirements.

Backyard Paradise

Sales Budget

For the Quarter Ended March $31$

Data table

Requirements

Prepare the following budgets for the first three months of the year, as well

as a summary budget for the quarter:

Prepare the sales budget, including a separate section that details

the type of sales made $($cash versus credit.$)$

Prepare the production budget.

Prepare the direct materials purchases budget. Assume the

company needs $100,000$ board feet of wood for production in April.

Prepare the cash collections budget for January, February,

and March, as well as a summary for the first quarter.

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.