Question

In: Accounting

A relatively new company, Wine To End Whining, Inc., has determined they need to engage in...

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 2017: 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, 2016 Balance Sheet. Please complete the four items requested on Worksheet Tabs A, B, C, and D of this Workbook.

Use the information provided on the December 31, 2016 Balance Sheet shown below to help you create the budgeting documents requested.

WINE TO END WHINING, INC.
PLANNING DATA FOR 2017
All Sales are on Credit
      Collections of Accounts Receivable:
Month of Service 56%
Month following Service 44%
Actual December 2016 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. 60%
Planned ending inventory as a percentage of next month's required inventory. 65%
Purchases are are all on credit.
Purchases paid in current month 30%
Purchases paid in next month 70%
Sales commission as a percent of sales 3%
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%
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, 2017 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%
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 3.5%
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 2017
Income Tax rate 30%
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.
WINE TO END WHINING, INC.
BALANCE SHEET
December 31, 2016
ASSETS
Current Assets
Cash $       103,200
Accounts Receivable              88,000
Inventory              85,800
Prepaid Insurance                1,500
Total Current Assets           278,500
Property Plant and Equipment
Office Equipment           300,000
Accumulated Depreciation           (60,000)
Total Property Plant and Equipment           240,000
Total Assets $       518,500
LIABILITIES AND SHAREHOLDERS EQUITY
LIABILITIES
Current Liabilities
Accounts Payable - Purchases $         89,460
Sales Commission Payable                6,000
Selling and Admin Payable                4,000
Advertising Payable                2,000
Interest Payable                    467
Dividends Payable                       -  
Income Taxes Payable              14,970
Total Current Liabilities           116,897
Long Term Debt           160,000
Total Liabilities           276,897
SHAREHOLDERS' EQUITY
Common Stock           124,000
Retained Earnings           117,603
Total Shareholders' Equity           241,603
Total Liabilities and Shareholders Equity

$       518,500

WINE TO END WHINING, INC.
BUDGETED INCOME STATEMENTS
For the Month Ending,
Jan 31, 2017 Feb 28,2017 Mar 31, 2017
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

Solutions

Expert Solution

1. Purchases Budget is as follows:

Notes:

1. Sales amounts are expected and the same are given in the question.

2. It is given that Cost of goods sold are 60% of sales. Therefore, COGS = Sales x 60% for every month.

3. Ending Inventory is 65% of next month's required inventory. That is, ending inventory of Month 1 will be 65% of COGS of Month 2.

4. Opening Inventory + Purchases - Ending Inventory = Cost of Goods Sold, it can be alternatively written as,

Cost of Goods Sold + Ending Inventory - Beginning Inventory = Purchases. With this formula, we got the amount of Purchases.

2. Cash Budget is as follows:

Notes:

1. Opening Cash Balance for January is given.

2. Sales are on credit. 56% of Sales made in Month 1 will be received in Month 1 and 44% of Sales made in Month 1 will be received in Month 2(following month). Likewise, we made the cash realizations.

3. Sales commissions, Variable portion of Selling and Administration expenses, Variable portion of Advertising expenses are paid the month after there occurence. The given percentage of sales are used in their calculations. These accruals are even recognized as current liabilities in Balance sheet.

4. Fixed portion of Advertising and Selling&Administration expenses are paid in the month of occurence and disbursed by cash.

5. Remaining payments are recognized in the month of occurence as provided in the question.

_______________

3. Budgeted Income Statement is as follows:

4. Budgeted Balance Sheet is as follows:


Related Solutions

A relatively new company, Wine To End Whining, Inc., has determined they need to engage in...
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 2017: 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,...
A relatively new company, Wine To End Whining, Inc., has determined they need to engage in...
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 2017: 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,...
Spark Inc is a relatively new company and you have been recruited to assist the management...
Spark Inc is a relatively new company and you have been recruited to assist the management with advice and getting to the correct financial figures. 1. Distinguish between a stock split and a stock dividend. Is there any reason for the difference in accounting treatment of these two events? 2. Assume that when you were in high school you saved $1,000 to invest for your college education. You purchased 200 shares of Smiley Incorporated, a small but growing company. Over...
Need this in Javascript. 1. Profit Calculator A company has determined that its annual profit is...
Need this in Javascript. 1. Profit Calculator A company has determined that its annual profit is typically 23 percent of total sales. Write a program using the file name sales_prediction.js, that displays the profit based on the user entered amount of total sales for the year. ( Program prompt the user for the projected total sales amount ). Display the profit amount formatted to two decimal places. 5 POINTS 2. Pounds to Kilogram Converter Write a program using the file...
N is a tuxedo rental company for the most high-end occasions. The business owner has determined...
N is a tuxedo rental company for the most high-end occasions. The business owner has determined that its operating circumstances are quite suitable for use of the Baumol-Tobin cash management model. The business consistently earns an annual rate of return of 3.2% on its marketable securities and requires a total of $10,000,000 in cash each year to maintain its level of operations. Transactions costs are $100 each time it is necessary to liquidate marketable securities. Assume a 365-day year. Answer...
2. A computer company looking for a new location for a plant has determined three criteria...
2. A computer company looking for a new location for a plant has determined three criteria to use to rate cities. Pair-wise comparisons are given below. Recreation Opportunities Proximity to University Cost of Living Recreation Opportunities 1 1/3 1/5 Proximity to University 3 1 1/4 Cost of living 5 4 1 (b) Calculate the consistency ratio.
Bird's Eye Treehouses, Inc., a Kentucky company, has determined that a majority of its customers are...
Bird's Eye Treehouses, Inc., a Kentucky company, has determined that a majority of its customers are located in the Pennsylvania area. It therefore is considering using a lockbox system offered by a bank located in Pittsburgh. The bank has estimated that use of the system will reduce collection time by 2.5 days. Assume 365 days a year.      Average number of payments per day 840   Average value of payment $ 790   Variable lockbox fee (per transaction) $ 0.20   Annual interest...
Bird's Eye Treehouses, Inc., a Kentucky company, has determined that a majority of its customers are...
Bird's Eye Treehouses, Inc., a Kentucky company, has determined that a majority of its customers are located in the Pennsylvania area. It therefore is considering using a lockbox system offered by a bank located in Pittsburgh. The bank has estimated that use of the system will reduce collection time by 2 days. Assume 365 days a year.      Average number of payments per day 780   Average value of payment $ 730   Variable lockbox fee (per transaction) $ .15   Annual interest...
Bird's Eye Treehouses, Inc., a Kentucky company, has determined that a majority of its customers are...
Bird's Eye Treehouses, Inc., a Kentucky company, has determined that a majority of its customers are located in the Pennsylvania area. It therefore is considering using a lockbox system offered by a bank located in Pittsburgh. The bank has estimated that use of the system will reduce collection time by 2 days.    Average number of payments per day 770 Average value of payment $ 720 Variable lockbox fee (per transaction) $ .20 Annual interest rate on money market securities...
Bird's Eye Treehouses, Inc., a Kentucky company, has determined that a majority of its customers are...
Bird's Eye Treehouses, Inc., a Kentucky company, has determined that a majority of its customers are located in the Pennsylvania area. It therefore is considering using a lockbox system offered by a bank located in Pittsburgh. The bank has estimated that use of the system will reduce collection time by 2 days. Assume 365 days a year. Average number of payments per day 780 Average value of payment $ 730 Variable lockbox fee (per transaction) $ .15 Annual interest rate...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT