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

Answer

30