# Hello, I have started on my ” Chapter 6 Case Problem 1: Kelly’s

### Question Description:

30

Hello, I have started on my “Chapter 6 Case Problem 1: Kelly’s Boutique”. I’m getting a little confused as to where to place the numbers now, because in the homework it says expected #, but it actually should be placed in the assumption area within the template I am doing. Could you please help me figure out what to do? I did as much as I could do (that I thought was correct placement). I would appreciate your help! ch6-04_Kathrina_Maddox.xlsx Kelly’s Boutique Cash Budget Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Operating activities \$ – Operating cash receipts \$ – Product sales revenue \$ – Collections in the month of sale Collections in the 1st month following a sale \$ \$ – Collections in the 2nd month following a sale Operating cash receipts Operating cash payments Purchases Cost of expected sales \$ \$ \$ \$ \$ – Required ending inventory Beginning inventory \$ \$ \$ 11,000 11,000 Purchases \$ – Payments in the month of purchase Payments in the 1st month following a purchase Payments in the 2nd month following a purchase Cash payments for purchases \$ \$ \$ \$ – Expenses Advertising expense Interest expense Payroll expense Supplies expense Utilities expense Expenses Operating cash payments Cash from (to) operating activities Investing activities Equipment purchases Other Cash from (to) investing activities \$ \$ \$ \$ 900 1,000 8,000 500 \$ \$ \$ \$ 900 1,000 8,000 500 \$ 600 \$ 600 \$ 900 \$ 900 \$ 900 \$ 900 \$ \$ 1,000 \$ 1,000 \$ 1,000 \$ 1,000 \$ \$ 8,000 \$ 8,000 \$ 8,000 \$ 8,000 \$ \$ 500 \$ 500 \$ 500 \$ 500 \$ \$ 600 \$ 600 \$ 600 \$ 600 \$ 900 1,000 8,000 500 \$ 900 \$ 900 \$ 900 \$ 900 \$ 1,000 \$ 1,000 \$ 1,000 \$ 1,000 \$ 8,000 \$ 8,000 \$ 8,000 \$ 8,000 \$ 500 \$ 500 \$ 500 \$ 500 600 \$ 600 \$ 600 \$ 600 \$ 600 \$ – \$ \$ Beginning cash \$ 15,000 Ending cash \$ 15,000 – Assumptions January sales 55% 70% Beginning inventory Payments in the month of purchase Payments in the 1st month following a purchase Payments in the 2nd month following a purchase Previous December purchases Interest expense Payroll expense Supplies expense Utilities expense Loan proceeds Loan payment Equipment purchase 600 \$ – \$ – \$ – \$ – \$ – \$ (200,000) \$ – \$ – \$ – \$ – \$ – \$ \$ \$ \$ \$ 10,800 12,000 96,000 6,000 \$ \$ \$ \$ 7,200 – \$ \$ \$ \$ \$ \$ Loan payments Cash from (to) financing activities Change in cash Previous November purchases Beginning cash Next January forecasted sales Advertising expense Depreciation expense \$ \$ (200,000) Financing activities Loan proceeds Sales growth each month Collections in the month of sale Collections in the 1st month following a sale Collections in the 2nd month following a sale Previous December sales Previous November sales Cost of expected sales Required ending inventory \$ 900 \$ 1,000 \$ 8,000 \$ 500 \$15,000.0 \$ \$ – \$ \$ – \$ \$ – \$ \$ – \$ \$ – \$ 1,400 \$ 1,400 \$ 1,400 \$ 1,400 \$ 1,400 \$ 1,400 \$ 1,400 \$ 1,400 \$ 1,400 \$ 1,400 \$ (198,600) \$ 1,400 \$ 1,400 \$ 1,400 \$ 1,400 \$ 1,400 \$ \$ 1,400 \$ \$ 1,400 \$ \$ – \$ – \$ – \$ – \$ – \$ (198,600) \$ 1,400 \$ 1,400 \$ 1,400 \$ 1,400 \$ 1,400 \$ \$ (200,000) (200,000) 8,400 8,400 (191,600) 15,000 (176,600) Read more