a. An estimate of sales by Units and Rupee for each of the three Cities and...

 

Transcribed Image Text:

a. An estimate of sales by Units and Rupee for each of the three Cities and in Totals b. Production Budget (in Units) c. Direct Material Budget (In Units and Amount) Expected Sale Analysis Product Expected Sale Esti price per Unit Plastic A 90,000 150 2 Kg Brass 2 Kg Aluminum - Steel 2 Kg B 70000 400 3 50000 200 D 150000 110 3 - 3 3 1 3 - 1 3 1 2 Expected Sale Percentage in 3 Cities Cities A B C D Karachi 40% 30 25 35 Rawalpindi 25% 50 45 40 Peshawar 35% 20 30 25 Estimated Inventories Material Beginning Ending Price/Kg Plastic 1000 Kg 4000 Kg Rs.3 Brass 1500 5000 4 Aluminum 3000 2500 5 Steel 4000 8000 6 Finished Good Inventory Status Product Beginning Ending A 2000 Units 10000 Units B 3000 3000 C 5000 1500 D 4000 6000 a. An estimate of sales by Units and Rupee for each of the three Cities and in Totals b. Production Budget (in Units) c. Direct Material Budget (In Units and Amount) Expected Sale Analysis Product Expected Sale Esti price per Unit Plastic A 90,000 150 2 Kg Brass 2 Kg Aluminum - Steel 2 Kg B 70000 400 3 50000 200 D 150000 110 3 - 3 3 1 3 - 1 3 1 2 Expected Sale Percentage in 3 Cities Cities A B C D Karachi 40% 30 25 35 Rawalpindi 25% 50 45 40 Peshawar 35% 20 30 25 Estimated Inventories Material Beginning Ending Price/Kg Plastic 1000 Kg 4000 Kg Rs.3 Brass 1500 5000 4 Aluminum 3000 2500 5 Steel 4000 8000 6 Finished Good Inventory Status Product Beginning Ending A 2000 Units 10000 Units B 3000 3000 C 5000 1500 D 4000 6000