Trish Morrow Owns and Operates Yummy Bakery Which Sells a Wide

question 76

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:
o Wages $10,000
o Rent $4,000
o Utilities $3,500
o Insurance $2,500
o 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.

---

Definitions:

Dot

A small round mark or spot, often used in writing or printing to signify a full stop or a part of a lowercase letter.

Wedge

A piece of material, typically metal or wood, with a sharp edge that tapers to a thin point, used for splitting, lifting, or securing.

Horseshoe

In symbolic logic, the horseshoe symbol represents the conditional or "if...then" statement, highlighting a logical relationship between two propositions.

Negations

Logical operations that invert the truth value of a given statement, turning true statements into false and vice versa.