Direct Material 1:

Direct material item name

maidha flour

Quantity required for each unit of product

maidha 1 kg

Desired ending inventory as a percentage of following months production requirement

5 kg per month

Price per unit of direct material

5 kg per 2000

Direct Material 2:

Direct Material Name	sugar
Quantity Required for Each Unit of Product	5 kg
Desired Ending Inventory as a Percentage of Following Months Production Requirement	30 kg
Price Per Unit of Direct Material 100 per kg	100 per kg

Direct Material 3:

Direct Material Name	oil
Quantity Required for Each Unit of Product	2 kg
Desired Ending Inventory as a Percentage of Following Months Production Requirement	100 kg
Price Per Unit of Direct Material	cost is 100 per kg

Equipment Name

Cost

Useful Life

Depreciation Expense

stove

25000

8 years

15000

gas

5000

7 years

2000

equipment 100000 10 years 50000

Fixed MOH Expense Item Name

Fixed Expense Per Month

maida flour 10000

sugar 10000

oil 300000

Total selling and administrative (SnA) expense = Variable SnA + Fixed SnA

= 320000 + 130000 = 450000

ll over the next 12 months. Fill out the following table about sales estimates

Month	Estimated Units of Product Sold
September	1000
October	900
November	800
December	1100
January	700
February	500
March	1500
April	2200
May	2800
June	1350
July	2000
August	850
total units	15,700

per unit 5 rupess 15700x 60 = 9420000.

tota amount received 9420000 end of the year.

my investment is 500000

borrowing from my friend 200000

total amount 700000

my return end of the year is 9420000.

profit of my business is 9420000-700000 = 2420000

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. SnA Expense Budget 5. Cash Budget Note: You will not need any production budget since units sold = units produced every month. Thus, the sales estimates you have formed above will also be used as the number of units produced in the Master Budget.