Question
Lily Potter is the owner of a Gift Shop. Lily wants to make a cash budget for the second three months of the calendar year
Lily Potter is the owner of a Gift Shop. Lily wants to make a cash budget for the second three months of the calendar year 2022. Her sales and purchase departments have given her the following estimates: Marks: 20 Month Sales in BDT Purchases in BDT January 2022 221,000 110,000 February 2022 226,000 120,000 March 2022 228,000 130,000 April 2022 230,000 140,000 May 2022 236,000 150,000 June 2022 238,000 160,000 Sales are made on cash basis only. The payments for purchases are made: payment within the same month of purchase will be 40%, payment in the month following purchase: 50%, and payment in the second month following purchase: 10%. Lily plans to offer 5% discount to the customers who make payments within the same month of sales. General and administrative salaries will be 9% of monthly sales. Lease payments will amount to BDT 63,000 a month. Depreciation expenses are expected to be BDT 53,000 a month. Tax payment of BDT 25,000 will be due in June. Cash on hand on April 1 might be BDT 48,000. The Gift Shop wants to maintain a target minimum cash balance of BDT 120,000 a month.
(a) Prepare cash budget for the Gift Shop for the second three months of 2022 (April to June).
(b) In which months, can the Gift Shop go for an investment of BDT 45,000?
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