Trish Morrow Owns and Operates Yummy Bakery Which Sells a Wide

question 63

Essay

Trish Morrow owns and operates Yummy Bakery which sells a wide variety of cupcakes. She has compiled the following data and information in order to put together a cash budget for September and October.
$\bullet$ Budgeted sales for September are 65,000 cupcakes and 98,000 in October. Each cupcake sells for $3.50.
$\bullet$ On average 60% are cash sales and 40% are done on account.
$\bullet$ The company expects to collect 75% of credit sales in the month of the sale and 20% in the month after the sale.
$\bullet$ All necessary raw materials are purchased on account. Purchases are paid 85% in the month of the purchase and 15% in the following month. Purchases for September are estimated to be $200,000 and $290,000 in October.
$\bullet$ Monthly expenses include:
$\bullet$ Wages $10,000
$\bullet$ Rent $4,000
$\bullet$ Utilities $3,500
$\bullet$ Insurance $2,500
$\bullet$ Advertising $2,290
$\bullet$ Cash balance on September 1^st was $6,000.
$\bullet$ The company has a policy to maintain a minimum cash balance of $5,000. If necessary the company will borrow to meet its short-term needs. All borrowing is done at the beginning of the month and all payments on principal and interest are made at the end of the next month. The annual interest rate is 7%. The company must borrow in multiples of $1,000.
$\bullet$ August sales were 43,000 cupcakes and raw materials purchased equal $230,000.
Prepare a cash budget for September and October.