Answered step by step
Verified Expert Solution
Question
1 Approved Answer
X Ltd manufactures and sells one product. You are presented with the following information for the preparation of the annual operating budget for the period
X Ltd manufactures and sells one product. You are presented with the following information for the preparation of the annual operating budget for the period ending 31 December 2016:
- Estimated sales in units are 50,000 units for quarter 1, 55,000 units for quarter 2, 55,000 units for quarter 3, and 50,000 units for quarter 4. The estimated per unit selling price is $50 for quarters 1 and 2, and $50.50 for quarters 3 and 4.
- X Ltd has set the desired ending inventory of its product at 5% of the next quarters sales units. It is expected that X Ltd will sell 50,000 units in quarter 1 and 60,000 units in quarter 2 of 2017. The beginning inventory on 1 January 2016 is 5000 units.
- X Ltd uses 5 kg of direct material to produce its product. X Ltd has set the desired ending inventory of its direct material at 10% of the next quarters manufacturing needs. The beginning inventory on 1 January 2016 is 90,000 kg of direct material. X Ltd has secured a contract price with a supplier, in which the supplier will provide direct materials at a cost of $2.50 per kg over the next 18 months.
- X Ltds product is manufactured in batches of 50 units. Each batch requires 10 direct labour hours at a cost of $25 per hour.
- The estimated variable overhead rate is $20 per direct labour hour. X Ltd estimated the total fixed overhead cost for the year to be $1,500,000.
Required
Prepare the following budgets for the period ending 31 December 2016:
(i) Sales budget.
(ii) Production budget.
(iii) Direct material purchases budget.
(iv) Direct labour budget.
(v) Overhead budget.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started