On January 1st, 2018. After its first year of operation, CC’s president, Allen Hale, is now...

On January 1^st, 2018. After its first year of operation, CC’s president, Allen Hale, is now trying to prepare the company’s 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:

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.

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 month’s cost of goods sold. All purchases are made on account.

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

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.

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.

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

Expert Solution

	jan	feb
sales(=1.03*sale of prev mnth)	124300	128029
COGS(0.40*sale)	49720	51212
supply expense(0.03*sales)	3729	3841
commission(0.06*sales)	7458	7682

RECEIPT AMOUNT
sales(=1.03*sale of prev mnth)	124300	128029
cash sales(0.45*sales)	55935	57613
credit sales(0.55*sales)	68365	70416
collection of credit sales (in next /following mnth)		68365

COGS	49720	51212
closing inventory(0.25*next mnth cogs)	12803	13187
opening	0	12803
net purchase	62523	51596
payment(80%*net purch same mnth)	50018	41277
BALANCE(20%*net purch on next mnth)		12505
		(0.20*62523)

	CASH BUDGET
	RECEIPT
	sales - cash	55935	57613
ADD	- credit sales collection		68365
	amount before loan (A)	55935	125978



	Payments
	purchase	50018	53781	(41277+12505)
ADD	salary	36400	36400
ADD	utility	6400	6400
ADD	commission		7458
ADD	Rent	5200	5200
ADD	misc exp	3200	3200
ADD	suplly expense	3729	3841
ADD	equipment	180000
	INTEREST 0.3%*LOAN		810	0.3%*270000
	Payments (B)	284947	117090
	net before loan (A-B) C	-229012	8888
	minimum closing cash balance (D)	40000	40000
	loan (D-C)	269012	31112
	In terms of 1000	270000	32000

ekkarill92 answered 1 month ago

CDD Corp., was organized on January 2, 2018. During the first year of operation, CDD issued...

CDD Corp., was organized on January 2, 2018. During the first year of operation, CDD issued 60,000 shares of $3 par value common stock at a price of $40 cash per share. On December 31, 2018, CDD reported Net Income of $200,000 and paid $40,000 cash dividends. Use this information to determine the dollar amounts that CDD will report on its year-end Balance Sheet for Paid in Capital Common Stock in Excess to par. Acct. 220

Johnsn and Hill formed a company, and 2018 was their first year of operation. a) To...

Johnsn and Hill formed a company, and 2018 was their first year of operation. a) To establish Johnson & Hill each contributed a total of $55,000 in exchange for common stock. b) Johnson & Hillt specializes in high-end parties. The first year they conducted 96 events and revenue for the first year amounted to $480,000, of which 95% was to be paid by the date of the event and the remainder due within 30 days of the event c) Clients...

Mangra Co planned and actually manufactured 200,000 units in 2018, its first year of operation. Variable...

Mangra Co planned and actually manufactured 200,000 units in 2018, its first year of operation. Variable manufacturing cost waz $20 per unit produced. Variable S&A expense was $10 per unit sold. Planned and actual fixed manufacturing costs were $600,000. Fixed S&A cost was $400,000. 120,000 units were sold at $40 per unit. Prepare an Absorption Costing Income Statement

Cordell Inc. experienced the following events in 2018, its first year of operation: 1. Received $40,000...

Cordell Inc. experienced the following events in 2018, its first year of operation: 1. Received $40,000 cash from the issue of common stock. 2. Performed services on account for $82,000. 3. Paid a $6,000 cash dividend to the stockholders. 4. Collected $76,000 of the accounts receivable. 5. Paid $53,000 cash for other operating expenses. 6. Performed services for $19,000 cash. 7. Recognized $3,500 of accrued utilities expense at the end of the year. Required a. Identify the events that result...

Johnsn and Hill formed a company, and 2018 was their first year of operation. To establish...

Johnsn and Hill formed a company, and 2018 was their first year of operation. To establish Johnson & Hill each contributed a total of $60,000 in exchange for common stock. Johnson & Hill specializes in high-end parties. The first year they conducted 94 events and revenue for the first year amounted to $480,000, of which 95% was to be paid by the date of the event and the remainder due within 30 days of the event. Clients owe $16,000 at...

After tallying the receipts for their first year of operation, the owners of the Taco Barn...

After tallying the receipts for their first year of operation, the owners of the Taco Barn are encouraged. Sales of their artisnal tacos, made from such exotic ingredients as ground beef, cheese, and beans, have been strong and seem to give hope to the coming year. Taco sales by month are shown in the table. Armed only with his fingers, the owner decides that the safest forecasting approach is a linear trend line. Generate a forecast for the year using...

On January 1st 2018 the Black Panther Company issued (sold) $800,000 10 year 6% bonds to...

On January 1st 2018 the Black Panther Company issued (sold) $800,000 10 year 6% bonds to yield 8% These bonds pay interest on July 1 and January 1 each year. Each of these $1000 par bonds could be converted into 20 shares of Black Panther common stock a) make the journal entry Black Panther makes when they issue the bonds. b) make the journal entry Black Panther makes when it makes the first interest payment on July 1 2018 c) make the...

Choctaw Co. completed the following transactions in 2018, the first year of operation: Issued 31,000 shares...

Choctaw Co. completed the following transactions in 2018, the first year of operation: Issued 31,000 shares of $10 par common stock for $10 per share. Issued 4,100 shares of $20 stated value preferred stock for $20 per share. Purchased 2,100 shares of common stock as treasury stock for $12 per share. Declared a $3,100 cash dividend on preferred stock. Sold 800 shares of treasury stock for $14 per share. Paid $3,100 cash for the preferred dividend declared in Event 4....

Choctaw Co. completed the following transactions in 2018, the first year of operation: Issued 28,000 shares...

Choctaw Co. completed the following transactions in 2018, the first year of operation: Issued 28,000 shares of $10 par common stock for $10 per share. Issued 3,800 shares of $20 stated value preferred stock for $20 per share. Purchased 1,800 shares of common stock as treasury stock for $12 per share. Declared a $2,800 cash dividend on preferred stock. Sold 800 shares of treasury stock for $14 per share. Paid $2,800 cash for the preferred dividend declared in Event 4....

A firm has a fixed cost of $20,000 in its first year of operation. When the...

A firm has a fixed cost of $20,000 in its first year of operation. When the firm produces 1,000 units of output, its total costs are $80,000. When it produces 1,100 units of output, its variable costs are $70,000. If the marginal cost of each of the 100 additional units of output is the same then the marginal cost of producing the 1,050th unit of output is less than $90. True false The average variable cost curve and average total...

Question