Prepare the functional budgets for the financial quarter January to March

$2$

$0$

$2$

$4$

$$from the information provided in the excel file, and comment on your findings. Discuss any areas of strength or weakness, identified in the budget.The following information relate to projected figures of the new line of building materials for the year $2024$

Sales Information:

Sales projections for unit sales are as follows, with an estimated average selling price per unit of $130$ :

January: $6,500$ units

February: $7,800$ units

March: $7,200$ units

April: $6,300$ units

May: $5,500$ units

Production Information:

The starting inventory of finished goods on January $1$st stands at $4,500$ units. To ensure constant customer demand fulfilment, the sales manager insists on $n$

Raw Materials Information:

Each unit produced necessitates $3$ kilograms of material, with an estimated cost of $4$ per kilogram. The raw materials inventory on January $1$ st is $13,420$ kilo

Labour Information:

Every unit produced requires $3$ skilled labor hours and $2$ unskilled labor hours. Skilled labor costs $f16$ per hour, while unskilled labor costs $f6$ per hour.

Production Overheads Information:

Production overheads are allocated at a rate of $3\mathrm{.}50$ per direct labor hour.

Administration Overheads Information:

Administration overheads are initially budgeted at $26,750$ for January and are expected to escalate by $8\%$ monthly.

Selling Overheads Information:

Selling overheads account for $14\%$ of monthly sales revenue. The sales manager believes that the current average selling price per unit of $130$ is at the upp