Direct Material 1: over the next 12 months. Fill out the following table about sales estimates. maidha flour Month Estimated Units of Product Sold maidha 1 kg 5 kg per month 1000 900 5 kg per 2000 Direct Material item name Quantity required for each unit of product Desired ending inventory as a percentage of following month's production requirement Price per unit of direct material Direct Material 2: Direct Material Name Quantity Required for Each Unit of Product Desired Ending Inventory as a Percentage of Following Month's Production Requirement Price Per Unit of Direct Materia 800 1100 700 suger 5 kg 30 kg April May June July August September October November December January February March Total Units per unit 5-taka 15700x 60 = 9420000. 500 1500 2200 2800 1350 2000 850 15,700 100 per kg Direct Material 3: oil 2 kg Direct Material Name Quantity Required for Each Unit of Product Desired Ending Inventory as a Percentage of Following Month's Production Requirement Price Per Unit of Direct Material 100 kg Total amount received 9420000 ends of the year. 100 per kg My investment is 500000 Equipment Name Cost Useful Life Depreciation Expense borrowing from my friend 200000 stove gas 25000 5000 8 years 7 years 15000 2000 total amount 700000 equipment's 100000 10 years 50000 my returns end of the year is 9420000. Fixed MOH Expense Item Name Fixed Expense Per Month profit of my business is 9420000-700000 = 2420000. maida flour 10000 oil 300000 Requirements: Based on the assumptions you have formed above, prepare a Master Budget consisting of the following components in the Google Sheet attached to this assignment. 1. Sales Budget [No schedule of cash collection will be needed as all sales are on cash.] 2. Direct Material Budget(s) [Make a separate budget for each direct material. No schedule of cash disbursements for direct material will be necessary as all purchases will be made in cash.]3. MOH Budget.4. Sn'A Expense Budget5. Cash Budget sugar 10000 Total selling and administrative (SnA) expense = Variable Sn'A + Fixed Sn'A = 320000 + 130000 = 450000 Direct Material 1: over the next 12 months. Fill out the following table about sales estimates. maidha flour Month Estimated Units of Product Sold maidha 1 kg 5 kg per month 1000 900 5 kg per 2000 Direct Material item name Quantity required for each unit of product Desired ending inventory as a percentage of following month's production requirement Price per unit of direct material Direct Material 2: Direct Material Name Quantity Required for Each Unit of Product Desired Ending Inventory as a Percentage of Following Month's Production Requirement Price Per Unit of Direct Materia 800 1100 700 suger 5 kg 30 kg April May June July August September October November December January February March Total Units per unit 5-taka 15700x 60 = 9420000. 500 1500 2200 2800 1350 2000 850 15,700 100 per kg Direct Material 3: oil 2 kg Direct Material Name Quantity Required for Each Unit of Product Desired Ending Inventory as a Percentage of Following Month's Production Requirement Price Per Unit of Direct Material 100 kg Total amount received 9420000 ends of the year. 100 per kg My investment is 500000 Equipment Name Cost Useful Life Depreciation Expense borrowing from my friend 200000 stove gas 25000 5000 8 years 7 years 15000 2000 total amount 700000 equipment's 100000 10 years 50000 my returns end of the year is 9420000. Fixed MOH Expense Item Name Fixed Expense Per Month profit of my business is 9420000-700000 = 2420000. maida flour 10000 oil 300000 Requirements: Based on the assumptions you have formed above, prepare a Master Budget consisting of the following components in the Google Sheet attached to this assignment. 1. Sales Budget [No schedule of cash collection will be needed as all sales are on cash.] 2. Direct Material Budget(s) [Make a separate budget for each direct material. No schedule of cash disbursements for direct material will be necessary as all purchases will be made in cash.]3. MOH Budget.4. Sn'A Expense Budget5. Cash Budget sugar 10000 Total selling and administrative (SnA) expense = Variable Sn'A + Fixed Sn'A = 320000 + 130000 = 450000