i already have section 1 done, i am struggling with 2 and 3 please help!!
SECTIONI PREPARATION OF A BUDGETED INCOME STATEMENT Cold Mountain Ice Cream Shoppe is an ice cream shop company that sells a franchised brand of single serve ice cream. Sales Budget The sales department of Cold Stone Creamery has determined that sales for 2020 will be 7% higher than sales in 2019. Actual 2019 sales were as follows: Month Unit sales Month Unit Sales January 2019 2,690 units July 2019 4,750 units February 2019 2,805 units August 2019 4,850 units March 2019 2,958 units September 2019 3,530 units April 2019 4,250 units October 2019 2,905 units May 2019 4,350 units November 2019 2,858 units June 2019 4,525 units December 2019 The average selling price per unit in 2019 was $4.50/unit. The company expects to increase the selling price by 8% in 2020. Cost of goods sold Each unit of ice cream costs 55% of the retail price Selling and Administrative expense Cold Mountain has to pay a franchise fee equal to 2.5% of sales revenue Salaries are $1,000 / month During the peak season (June-August) Cold Mountain hires additional sales people. The additional sales people's salaries are $800 per month During the peak season (June-August) Cold Mountain advertises. Advertising expense are $1,800 per month. Rent expense is fixed at $1,500 per month Utilities are $250 fixed plus $.05 per unit variable costs. Supplies are $500 per month in the peak season (May - August) and $250 per month in the offseason (Jan-April, Sept. - December) Depreciation on the store equipment is $250 per month Income taxes Cold Mountain's tax rate is 28% of Net Income before taxes Required: Using the spreadsheet provided on canvas, prepare a Budgeted Income Statement by month for Cold Stone Ice Cream Shoppe. SECTION II PREPARATION OF A MERCHANDISE PURCHASE AND CASH BUDGET A. MERCHANDISE PURCHASE BUDGET + - = Budgeted ending inventory Budgeted units sold Budgeted beginning inventory Inventory (units) to be purchased Beginning inventory on hand on January 1, 2020 is 2,100 units. Cold Mountain maintains an ending inventory equal to 70% of the next month's budgeted sales. Cold Mountain estimates January 2021 sales to be 2,100 units. Required: Prepare a Merchandise Purchase Budget for Cold Mountain Ice Cream Shoppe B. CASH BUDGET Beginning cash balance + Budgeted cash receipts - Budgeted cash disbursement - Budgeted ending cash balance Beginning cash balance on January 1, 2020 is $150,000. Assume 75% of sales are paid for in cash and 25% are paid with Cold Mountain credit cards. Credit cards are paid the following month. Beginning accounts receivable balance on January 2020 is $2,280. Cold Mountain purchases its inventory entirely on account. Full payment is made the month following the purchase. Accounts payable balance as of January 1, 2020 is $5,470. Franchise fees are paid the month following the sales (for example franchise fees for January are paid in February). Franchise fee expense for December 2019 was $250. Salaries, Rent, Utilities and Supplies expenses are paid for during the month in which they are incurred. Advertising expense is paid for in advance the month prior to the advertising campaign Taxes are paid the following year in April). Prior year taxes were $31,500. Required: Using the spreadsheet provided on canvas, prepare a Cash Budget for Cold Mountain Ice Cream Shoppe SECTION III BUDGET ANALYSIS Once the budget is complete, the actual results are compared against the budget. Included in the chart are the actual results for the year. Cold Mountain uses a flex budget to assess activity and revenue and spending variances. 1. Using the spreadsheet on Canvas, to complete the Variance Report 2. Using the eBook and powerpoint, analyze the results and answer the following questions for each of the 3 variances (1) Activity variance (2) Revenue variance and (3) Spending Variance a) Using the eBook define each variance b) What causes this variance (be specific) c) Who is responsible for this variance (job title) d) Is the variance favorable or unfavorable (for some it may be both) (be specific) Unit Sales Selling price per unit Actual 48,510 5.00 Sales Cost of goods sold Gross Profit 242,550 138,254 104,297 Selling & Administrative Franchise fee Sales salaries Advertising expense Rent expense Utilities expense Supplies Depreciation expense Total Selling & Administrative 6,064 13,500 5,000 18,600 6,230 3,950 3,000 56,344 Operating Income Income tax expense 47,953 7,776 Net income $ 40.177