T MA Manufacturing Company Ltd (MA Ltd) produces shea butter body lotion, christened Bizim, for both local and the West African market. A unit of Bizim is sold for GH¢10. Conventionally, the selling price for the product changes every other month by 10% due to the erratic nature of the environment in which MA Ltd operates. The last time the selling price was increased was the immediate month preceding the first month of this planning period. The demand for the product for the planning period averages every 30 days (equivalent to a month) as follows: Month 1 2 3 4 5 6 Demand (Units) 17,700 18,120 19,500 18,600 25,200 25,500 It is the policy of MA Ltd to keep closing inventory of finished goods to be equivalent to the sales level of 10 working days of next month’s sales. However, experience shows that 3% of each production goes defective and has to be scrapped with no scrap value. Product Bizim requires 2kg of material MAT. However, it is expected that a normal loss of 20% of material MAT will occur in the production process. It is the policy of MA Ltd to keep material inventory to cover 10 days of the following period’s production. Material usage in month 6 is estimated to be 30,000kg. The price of material MAT is budgeted to be GH¢3.50/kg. A unit of Bizim requires 1.5 hours to produce with a 75% productivity level because of regular maintenance. The Labour rate per hour is GH¢6, but only 39,500 hours can be worked within regular working hours. Overtime hours are paid at time and a half.
Required: Prepare the following budgets for the first five months for MA Ltd Company Ltd.
i) Sales (4 marks)
ii) Production (4 marks)
iii) Material Usage (4 marks)
iv) Material Purchase (4 marks) v
