On January 1^st, 2018. After its first year of operation, CCs president, Allen Hale, is now trying to prepare the companys master budget for the first two months (January and February) of 2019. Since you are his good friend and an accounting student, Mr. Hale has asked you to prepare the budget.

Based on the budgets from 2018, Mr. Hale has gathered the following information:

• Projected Sales for January 2019 $124,300
• Average Monthly Sales Increase 3%
• Average Monthly Salary Expenses $ 36,400
• Average Monthly Rent Expenses $ 5,200
• Average Monthly Utility Expenses $ 6,400
• Average Monthly Misc. Expense $ 3,200
• Supplies Expense-percent of sales 3%
• Commission-percent of sales 6%

Begin your project by carefully reading all instructions given here and reviewing the balance sheets and budget worksheets contained in the Excel workbook.

Fill in the data table in the upper left hand corner of the Budgets worksheet (found on the second tab in the Excel workbook) with the values above and other values found in the assumptions given below. Using this information, prepare Chippewa Chocolates master budget for the first two months of 2019. All amounts should be rounded to whole dollars as necessary. Apply the following assumptions:

1. Customers typically pay 45% of total sales in cash and the remaining 55% on account. The company expects to collect 100% of the credit sales in the month following the sale.

2. The cost of goods sold is 40% of budgeted sales and the company desires to maintain a minimum ending inventory equal to 25% of the next months cost of goods sold. All purchases are made on account.

3. The company pays 80% of inventory purchases in the month of purchase and the remaining 20% in the following month.

4. Depreciation expense on existing equipment is $4,000 each month. In addition, CC will spend $180,000 on January 1 for additional equipment. The equipment is expected to have a $7,200 salvage value and a four-year (48-month) useful life.

5. Salaries, utilities, and sales commissions are paid the month after they are incurred; all other expenses are paid in the month in which they are incurred.

6. The company borrows and repays funds on its credit line in increments of $1,000 on the last day of each month as necessary to maintain its targeted $44,000 cash balance. It pays interest of .3% per month in cash on the last day of the month on cash borrowed in the prior month.

Needs to be formatted on Excel