The Amos Limited manufactures and sells two chocolate products, Cute and Attractive. In

July $2023$ Amos Limited's Budget Department organized the following data in order to

prepare budgets for $2024$:

Projected Sales $2024$:

Position of Stock:

Material Consumption for manufacturing $1$ unit of product:

Projected data for $2024$ with respect to price and opening and closing stock were as follows s:

Projected direct manufacturing labor requirements and rates for $2024$ are as follows:

Manufacturing overhead is allocated at the rate of Rs$.38$ per direct manufacturing labour

hour.

Prepare the following budgets in excel. Attach excel table screenshots and explain the steps and formulas to calculate the questions:

Revenue budget $($in Rs$.)$

Production budget $($in units$)$

Direct materials purchase budget $($in quantities$)$

Direct materials purchase budget $($in Rs$.)$

Direct manufacturing labour budget $($in Rs$.)$

Budgeted finished goods inventory at December $31,2024($in Rs$.)$