A relatively new company, Wine To End Whining, Inc., has determined they need to engage in a budgeting process as part of their new strategic plan. The Company has asked you to provide the following items for the months of January, February, and March of 2021: A) a Purchases Budget; B) a Cash Budget; C) a Budgeted Income Statement; and D) a Budgeted Balance Sheet. They have provided you with the planning document below and also, with their December 31, 2020 Balance Sheet. Please complete the four items requested on Worksheet Tabs A, B, C, and D of this Workbook. Check Figures are provided for you on each Worksheet.
		WINE TO END WHINING, INC.
		PLANNING DATA FOR 2021
		All Sales are on Credit
		Collections of Accounts Receivable:
Month of Service	55.00%
Month following Service	45.00%
Actual December 2020 Sales	$ 200,000
Expected Sales in Dollars
January	$ 220,000
February	$ 193,000
March	$ 178,000
April	$ 201,000
Cost of Goods Sold as a percentage of selling price.	65.00%
Planned ending inventory as a percentage of next month's required inventory.	72.00%
Purchases are are all on credit.
Purchases paid in current month	34.00%
Purchases paid in next month	66.00%
Sales commission as a percent of sales	2.50%
Sales commission are paid one month after the month incurred.
Advertising expenses have a fixed and variable portion:
Fixed portion	$4,200
The fixed portion of the advertising is paid in the current month.
Variable portion as a percentage of sales	1.00%
The variable portion is paid one month after the month incurred.
Insurance policy:
Months of insurance coverage paid for	12
The policy period is from February 1 to January 31 each year
The premium to be paid on February 1, 2021 is	$18,000
The premium will be charged to prepaid insurance
Selling and Administrative expenses have a fixed and variable portion:
Fixed portion is paid in the month incurred	$29,000
Variable portion as a percentage of sales	2.00%
Variable S&A expenses are paid one month after the month incurred
Depreciation expense per month	$5,000
The annual interest rate on the long term debt is	4.50%
Interest is incurred on the principal balance outstanding each month.
Interest is paid on a quarterly basis. Interest for December to February will be paid March 1.
No principal payments are scheduled to be made on the long-term debt until September of 2021
Income Tax Rate	21.00%
Accrued taxes are paid on the 15th of January, April, July and October
The Company's Board of Directors plans to declare a dividend on January 20	$12,000
It will be paid on February 15.

Use the information provided on the December 31, 2020 Balance Sheet shown below to help you create the budgeting documents requested.
WINE TO END WHINING, INC.
BALANCE SHEET
December 31, 2020
ASSETS
Current Assets
Cash	103,200
Accounts Receivable	90,000
Inventory	102,960
Prepaid Insurance	1,500
Total Current Assets	297,660
Property Plant and Equipment
Office Equipment	300,000
Accumulated Depreciation	(60,000)
Total Property Plant and Equipment	240,000
Total Assets	537,660
LIABILITIES AND SHAREHOLDERS EQUITY
LIABILITIES
Current Liabilities
Accounts Payable - Purchases	91,978
Sales Commission Payable	5,000
Selling and Admin Payable	4,000
Advertising Payable	2,000
Interest Payable	600
Dividends Payable	-
Income Taxes Payable	12,970
Total Current Liabilities	116,548
Long Term Debt	160,000
Total Liabilities	276,548
SHAREHOLDERS' EQUITY
Common Stock	124,000
Retained Earnings	137,112
Total Shareholders' Equity	261,112
Total Liabilities and Shareholders Equity	537,660

Check figures are: January Budgeted Gross Margin = $77,000; February Budgeted Operating Income = $17,235; March Budgeted Net Income = $9,646.

Solution:

WINE TO END WHINING, INC.

BUDGETED INCOME STATEMENTS

For the Month Ending,

Jan 31, 2021

Feb 28,2021

Mar 31, 2021

Sales

Cost of Sales

Gross Margin

Other Operating Expenses

Commission Expense

Advertising Expense

Insurance Expense

Selling & Admin. Expense

Depreciation Expense

Total Other Operating Expenses

Operating Income

Other Income (Expense)

Interest Expense

Income Before Income Tax

Income Tax Expense

Net Income