Question

In: Accounting

The following is the sales forecast of Mazon Corporation which makes and sells a product called...

  1. The following is the sales forecast of Mazon Corporation which makes and sells a product called a Minitab for the upcoming fiscal year:

1st Quarter

2nd Quarter

3rd Quarter

4th Quarter

Budgeted unit sales

23,000

15,000

10,000

25,000

Past experience has shown that the ending inventory for each quarter is equal to 10% of the next quarter’s sales in units. The company expect to start the first quarter with 4,000 units. The desired ending finished goods inventory at the end of 4th Quarter is 3,000 units.

One Minitab requires 3.5 kilograms of the raw material Jurislon. The company wants to maintain monthly ending inventories of Jurislon equal to 20% of the following month's production needs. The beginning inventory of Jurislon on hand is 6,900 kilograms and the desire ending Jurislon for the 4th Quarter is 4,500 kilograms. The cost of Jurislon is $2.00 per kilogram.

Required: [13 Marks]

  1. Prepare a production budget for the year showing number of units to be produced each quarter and for the year in total.   
  2. Prepare direct materials budget by quarter and for the year in total. At the bottom of your budget, show the dollar amount of purchases for each quarter and for the year in total.

Solutions

Expert Solution

a. Production budget for the year showing number of units to be produced each quarter and for the year in total will be as follows:

b. Direct materials budget by quarter and for the year in total will be as follows:


Related Solutions

Caspion Corporation makes and sells a product called a Miniwarp. One Miniwarp requires 2.5 kilograms of...
Caspion Corporation makes and sells a product called a Miniwarp. One Miniwarp requires 2.5 kilograms of the raw material Jurislon. Budgeted production of Miniwarps for the next five months is as follows: August 23,500 units September 22,200 units October 23,600 units November 24,800 units December 24,500 units The company wants to maintain monthly ending inventories of Jurislon equal to 25% of the following month's production needs. On July 31, this requirement was not met since only 11,700 kilograms of Jurislon...
49. The Arkansas Company makes and sells a product called Product K. Each unit of Product...
49. The Arkansas Company makes and sells a product called Product K. Each unit of Product K sells for $25 dollars and has a unit variable cost of $19. The company has budgeted the following data for November: Sales of $1,162,200, all in cash. A cash balance on November 1 of $49,100. Cash disbursements (other than interest) during November of $1,170,000. A minimum cash balance on November 30 of $62,000. If necessary, the company will borrow cash from a bank....
Murphy Manufacturing Corporation makes and sells one product, cleverly named “Product X”. Product X normally sells...
Murphy Manufacturing Corporation makes and sells one product, cleverly named “Product X”. Product X normally sells for $100 per unit and is only sold in whole units! Production for April 2010 is expected to equal sales at a level of 32,000 units, which represents Murphy’s normal capacity. The company expects inventory levels to remain unchanged for the month. (Production equals sales). The following budget monthly estimates for manufacturing, selling and administrative expenses are available for normal capacity of 32,000 monthly...
Orr Company makes and sells a single product called a Bik. It takes six yards of...
Orr Company makes and sells a single product called a Bik. It takes six yards of Material A to make one Bik. Budgeted production of Biks for the next three months is as follows: Budgeted Biks to be Produced February 23,000 units March 19,000 units April 28,000 units The company wants to maintain monthly ending inventories of Material A that are equal to 39% of the following month's production needs. The cost of Material A is $1.20 per yard. The...
Topic:  Budgeting Lionel Ltd manufactures and sells Product X for $38 each. The sales forecast of this...
Topic:  Budgeting Lionel Ltd manufactures and sells Product X for $38 each. The sales forecast of this product for January, February and March and April 2021 is 12,000 units, 16,000 units, 22,000 units and 25,000 units respectively. Each unit of Product X requires 0.5 kg of material and 2.5 labour hours to produce. The material is bought from a local supplier at $4 per kg. The expected labour rate is $8 per hour. Factory overhead cost is allocated based on $0.6...
Klean N’ Kind Corporation sells one product which has a sales price of $250 each. The...
Klean N’ Kind Corporation sells one product which has a sales price of $250 each. The company operates with variable costs for this one product of $200 per unit. The company’s monthly fixed costs are $15,000. The applicable tax rate is 20%. Required: Using the Contribution Margin approach perform the following: 1. Calculate the contribution margin per unit. 2. Given a desired after tax profit of $68,000, compute the before tax profit. 3. Calculate the sales units needed to achieve...
Polik company makes and sells a single product called Ret. Operating at full capacity will give...
Polik company makes and sells a single product called Ret. Operating at full capacity will give 30000 units per year. Costs associated at this 30000 level of production are as follows: Direct material $450000 Direct labor $240000 Variable overhead $90000 Fixed overhead $270000 Variable selling $120000 Fixed selling $180000 Total $1350000 The Rets are normally sold for a price of $50 per unit. Fixed overhead of $270000 is for a range of 25000 to 30000 units per year. 2. Now...
Paine Ltd makes and sells a single product. Annual sales in units for 2017 are expected...
Paine Ltd makes and sells a single product. Annual sales in units for 2017 are expected to be 200,000, and standard cost and selling price per unit is: £ Selling price 35 Variable costs: Materials 8 Labour 8 Overheads 2 Annual fixed overheads for 2015 are budgeted at: Manufacturing: 600,000 Non-manufacturing 250,000 Actual production and sales for the first quarter was 45,000 units. The actual revenue and expenditure for the quarter was as follows: Sales revenue 1,720,000 Expenditure: Materials 365,500...
Tharaldson Corporation makes a product with the following standard costs:
Tharaldson Corporation makes a product with the following standard costs:    Standard   Standard   Quantity or Standard Price or Cost Per   Hours Rate Unit Direct materials 5.7 ounces $2.00 per ounce $11.40 Direct labor 0.8 hours $11.00 per hour $8.80 Variable overhead 0.8 hours $6.00 per hour $4.80 The company reported the following results concerning this product in June. Originally budgeted output 3,900 units Actual output 3,500 units Raw materials used in production 20,700 ounces Purchases of raw...
Milar Corporation makes a product with the following standard costs
Milar Corporation makes a product with the following standard costs: Standard Quantity or HoursStandard Price or Rate Direct materials 2.0 pounds $ 7.00 per pound Direct labor1.1 hours $19.00 per hour Variable overhead1.1 hours $ 7.00 per hour In January the company produced 4.800 units using 10,170 pounds of the direct material and 2.150 direct labor-hours. During the month, the company purchased 10,740 pounds of the direct material at a cost of $76.620. The actual direct labor cost was $38,251 and the actual variable overhead cost was $11,952. The company...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT