Question
1) GH Bros. is engaged in manufacturing cosmetic products and prepared the following information as a basis for its 2019 Budget. Products Expected sales Sale
1) GH Bros. is engaged in manufacturing cosmetic products and prepared the following information
as a basis for its 2019 Budget.
Products Expected sales Sale price per unit Per unit material required for use in
production of units sold
Material A Material B
X 160000 units Rs. 250 1 kg 2 kg
Y 80000 units 150 2 kg 1.5 kg
Z 200000 units 100 0.5 kg NIL
Estimated inventories at the beginning and desired quantities at the end of 2019 are:
Material Beginning Ending Price per kg (same
price for material
required for use in
production)
A 20000 kg 24000 kg Rs. 40
B 24000 kg 30000 kg 20
Products Beginning Ending
X 10000 units 12000 units
Y 8000 units 4000 units
Z 20000 units 16000 units
Sales information according to cities
X Y Z
Rawalpindi 20% 40% 50%
Islamabad 50% 40% 20%
Lahore 30% 10% Remaining
Required: Prepare sales budget, production budget, also calculate cost of raw material
purchased by preparing raw material budget.
2) A Company wants to prepare cash budget based on the following information. Forecast the cash
position for the months of October, November and December. Complete company's estimate.
Sales (Rs.) Purchases (Rs.) Salaries (Rs.) Other expenses (Rs.)
August 440000 168000 20000 11000
September 260000 520000 74000 16000
October 160000 304000 56000 12000
November 232000 412000 50000 24000
December 172000 320000 56000 12000
Additional Information:
Sales: 40% realized in the month of sales, discount on sales 3% in the same month. Balance
realized equally in two subsequent months by calculating on gross sales.
Accounts receivable consists of Rs. 100000, company receives 60% in October, and balance
received equally in last two months.
Company paid against Purchases in the month following the month of purchases.
30% of the salaries paid in the month of occurrence and remaining is paid in following month.
Other expenses paid in the month of occurrence.
Rent: Rs 1,000 per month paid quarterly in advance in current year during the month of
December.
Income-tax; Installment of advance tax of next year Rs 35,000 due on 15th December.
Cash in hand: Rs 5,000 on September 30.
Company arranges financing in case of deficit, if deficit is below Rs. 200000, company takes
loan from bank, if more than Rs. 200000, company issues shares.
Loan installment is due during November at Rs. 8000.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started