Question

In: Accounting

ACTIVITY BASED BUDGETING Fauji Fertilizer Ltd. manufactures Nitro-phosphorus Fertilizer. Sales are seasonal due to different crops....

ACTIVITY BASED BUDGETING

Fauji Fertilizer Ltd. manufactures Nitro-phosphorus Fertilizer.

Sales are seasonal due to different crops. The expected pattern of sales for the next year (2021) is as follows:

Quarter 1st 2nd 3rd 4th Year

Sales in tons 500 1,500 2,000 1,000 5,000

  • Each ton sells for Rs.25,000. All sales are on account, and Fauji’s experience with cash collections is that 55% of each quarter’s sales are collected during the same quarter as the sale. The remaining 45% of sales is collected in the quarter after the sale. Fauji experiences negligible bad debts, and so this is ignored in the budgeting process.

  • Sales in the fourth quarter of 2020 are Rs25,000,000 (1000 tons).

  • Fauji desires to have 10% of the following quarter’s sales needs in finished-goods inventory at the end of each quarter. (On December 31, 2020, Fauji expects to have 80 tons fertilizer in inventory.)

  • Each ton Fertilizer requires two tons of raw material. Fauji desires to have 10% of the next quarter’s raw material in inventory at the end of each quarter. (On December 31, 2020, Fauji expects to have 105 tons of raw material in inventory.)

  • The raw material price is Rs.5,000 per ton. The company buys its raw material on account and pays 65% of the resulting accounts payable during the quarter of the purchase. The remaining 35% is paid during the following quarter. (The raw-material purchases in the fourth quarter of 2020 are expected to be Rs.10,000,000.)
  • Each ton of fertilizer requires 5 labor hours, whereas one labor hour costs Rs.200.
  • Manufacturing-Overhead estimates for the year 2020 are as follows

Quarter 1st 2nd 3rd 4th Year

Unit-level costs:

Indirect material 24,000 72,000 96,000 48,000 240,000 Utilities 5,000 15,000 20,000       10,000        50,000

Batch-level costs:

Production runs 10 30 40 20 100

Setup 4,800 14,400 19,200 9,600 48,000 Purchasing 6,000 18,000 24,000 12,000 60,000

Quality control 6,000 18,000 24,000      12,000        60,000

Product-level costs:

Chemical engineering 10,000 10,000 10,000 10,000 40,000

Facility- and general-operations-level costs:

Supervisory salaries 100,000 100,000 100,000 100,000 400,000 Insurance 50,000 50,000 50,000 50,000 200,000 Maintenance 50,000 50,000 50,000 50,000 200,000 Utilities 80,000 80,000 80,000 80,000 320,000 Depreciation 200,000 200,000 200,000 200,000      800,000

  • Selling, General & Administrative Expense estimates for the year 2020 are as follows

Quarter 1st 2nd 3rd 4th Year

Unit-level expenses:

Sales Commission 15,000 45,000 60,000 30,500 150,000

Customer-level expenses:

Sales Salaries 90,000 270,000 360,000 180,000 900,000

Operator Salaries 50,000 150,000 200,000 100,000 600,000

Facilities and General Operations Expenses:

Packaging Design 19,200 19,200 19,200 19,200 76,800

Facility- and general-operations-level costs:

Manager salaries 152,500 152,500 152,500 152,500 610,000 Advertising 100,000 100,000 100,000 100,000 400,000

Admin. Salaries 147,500 147,500 147,500 147,500 590,000

  • Following is Investing and Financing estimate for the year 2020 are as follows

Quarter 1st 2nd 3rd 4th Year

Bank Loan (12%) 100,000,000

Loan Repayment 25,000,000 25,000,000 25,000,000 25,000,000 100,000,000

Plant Addition 20,000,000 50,000,000 12,000,000 5,000,000 87,000,000

Assuming same opening and ending balance in WIP, prepare all the budget schedules for 2021 except Balance Sheet (12 schedules). Include a column for each quarter, and for the year. This project should be done in MS Excel. Best of Luck!

Solutions

Expert Solution


Related Solutions

explain in detail what is the difference between activity based costing and activity based budgeting.
explain in detail what is the difference between activity based costing and activity based budgeting.
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...
which among these is plausible: 1. Zero based budgeting 2. Activity based budgeting 3. Rolling budget.
which among these is plausible: 1. Zero based budgeting 2. Activity based budgeting 3. Rolling budget.
QUESTION 2 (33 marks) (Module 5) Mist Fertilizer Ltd manufactures pre-mixed garden fertilizer for the garden...
QUESTION 2 (Module 5) Mist Fertilizer Ltd manufactures pre-mixed garden fertilizer for the garden centre retail market. The original ingredients including nitrogen, phosphorous and potassium components are mixed in the Primary Process Department (PPD). The fertilizer mix is then transferred to the Granulating and Blending Department (G&BD) for blending and drying (and where a final ingredient is added 70% through the process) and then the mix is transferred to the Bagging Department (BD) where the product is finished and bagged...
Explain why businesses are encouraged to adopt Activity Based Budgeting.
Explain why businesses are encouraged to adopt Activity Based Budgeting.
Activity-Based Flexible Budgeting Foy Company has a welding activity and wants to develop a flexible budget...
Activity-Based Flexible Budgeting Foy Company has a welding activity and wants to develop a flexible budget formula for the activity. The following resources are used by the activity: • Four welding units, with a lease cost of $15,000 per year per unit • Six welding employees each paid a salary of $60,000 per year (A total of 9,000 welding hours are supplied by the six workers.) • Welding supplies: $300 per job • Welding hours: 3 hours used per job...
Question 1: Activity-Based Costing (ABC) Doris Ltd manufactures two models of medical devices for blood testing...
Question 1: Activity-Based Costing (ABC) Doris Ltd manufactures two models of medical devices for blood testing as follows: N80 and N90. The company is currently using the traditional (absorption) costing method and overhead is applied to the products based on the number of units. Doris Ltd has decided to adopt activity-based costing (ABC) in the coming year. The company data concerning the current period’soperations appear below: N80 N90 Units produced 60,000 10,000 Number of parts needed (per unit) 12 20...
Ruby Company follows activity-based budgeting. From the information given below, calculate the total activity cost of...
Ruby Company follows activity-based budgeting. From the information given below, calculate the total activity cost of the company. Activity description Activity driver Cost per unit of driver Amount of driver Processing mail Number of clients $120 $75 Paying bills Number of bills $ 2.5 $10,000 Investigating Number of new hires $110 $75 Writing reports Number of clients $150 $75 a. $52,500 b. $52,800 c. $53,500 d. $53,200
Halo Inc. manufactures several different products including product A and product B. Halo uses activity-based costing,...
Halo Inc. manufactures several different products including product A and product B. Halo uses activity-based costing, such that the total manufacturing overhead for the month, of $750,000, is assigned to the following cost pools with the corresponding activity levels: Cost Pool Activity Cost Driver Setup $100,000 100 no. of setups Maintenance $250,000 1,250 machine hours Packing & Shipping $400,000 200 no. of deliveries The following information for products A and B for the current month is available: A B No....
Unused capacity, activity-based costing, activity-based management. Whitewater Adventures manufactures two models of kayaks, Basic and Deluxe,...
Unused capacity, activity-based costing, activity-based management. Whitewater Adventures manufactures two models of kayaks, Basic and Deluxe, using a combination of machining and hand finishing. Machine setup costs are driven by the number of setups. Indirect manufacturing labor costs increase with direct manufacturing labor costs. Equipment and maintenance costs increase with the number of machine-hours, and facility rent is paid per square foot. Capacity of the facility is 6,250 square feet, and Whitewater is using only 80% of this capacity. Whitewater...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT