Prepare the monthly budget for 2025 for a company$.$ The following estimates and information are available.

Selling and Administration expenses are $$12$ ?per unit and $$30,000$ ?per month. There is no depreciation included in this figure.

Dividends of $$500,000$ ?will be declared in December.

Due to payroll processing times, half of the wages earned by workers is paid in the month of production, and the other half is paid in the following month.

A Company has a very flexible work force that allows them to scale up or down without cost each month.

The selling price per unit is $$1,700$ ?except during May to August, inclusive, where increased competition requires a $$50$ ?price reduction.

Overhead is $$250,000$ ?per month plus $$28$ ?per direct labour hour. Overhead costs are all paid in the month they occur, and there is $$100,000$ ?per month in depreciation included.

Each unit requires $10$ ?hours of direct labour and $2$ ?pounds of metal to make.

Customer collections are received $48\%$ ?in the month of sale, $38\%$ ?in the next month, and $13\%$ ?in the second month following the sale. No further collections are received.

The company uses the absorption method of costing to calculate the finished goods inventory and cost of goods sold. They allocate manufacturing overhead on the basis of direct labour hours.

They have $820$ ?pounds of metal already in inventory. To prepare for supply disruptions of metal, the company likes to keep monthly ending inventory of metal high enough to meet the next two month's production requirements. In practice, their attempts at this might not always work out, but they were successful to end December $2024.$

Direct labour costs $$28$ ?per hour.

Accounts payable are paid $60\%$ ?in the month of purchase and $40\%$ ?in the following month.

Each pound of metal costs $$18\mathrm{.}50$

In December $2024,1,000$ ?pounds of metal were purchased and $1,050$ ?hours of Direct Labour worked.

Transcribed Image Text:

Sales are estimated as follows: Cash Finished units Month November 2024 Actual December 2024 Actual January 2025 February March April May June July August September October November December January 2026 February March Sales $ 340,000 374,000 306,000 238,000 510,000 1,020,000 1,980,000 2,640,000 2,722,500 2,145,000 1,020,000 935,000 510,000 306,000 340,000 306,000 544,000 A Company keeps a minimum amount of the following: A minimum of $2,500,000 Ending f/g inventory equal to 25% of next month's sales requirements Finished Goods Inventory units from December 2024 is equal to the targeted inventory policy. All sales are on account. Sales are estimated as follows: Cash Finished units Month November 2024 Actual December 2024 Actual January 2025 February March April May June July August September October November December January 2026 February March Sales $ 340,000 374,000 306,000 238,000 510,000 1,020,000 1,980,000 2,640,000 2,722,500 2,145,000 1,020,000 935,000 510,000 306,000 340,000 306,000 544,000 A Company keeps a minimum amount of the following: A minimum of $2,500,000 Ending f/g inventory equal to 25% of next month's sales requirements Finished Goods Inventory units from December 2024 is equal to the targeted inventory policy. All sales are on account.

Answer rating: 100% (QA)

Answer To prepare the monthly budget for 2025 for the company well break down the budget into various components such as sales production overhead cas... View the full answer