Question
In: Accounting
You were recently hired as an assistant controller at Just Tables (JT). JT sells one product, dining...
You were recently hired as an assistant controller at Just Tables (JT). JT sells one product, dining room tables made out of red cedar. You have been charged with preparing a cash budget for the second quarter (April to June) so that management can be aware of any financing requirements. You have collected the following information to assist you in preparation of the quarterly budget:
Recent and forecasted sales in units are as follows:
January (actual) 140
February (actual) 220
March (actual) 200
April 220
May 400
June 360
July 320
August 390
September 260
Tables are sold to retailers for $500 each. The company has a policy of having an ending inventory each month equal to 150% of the next month’s sales. The inventory balance at March 31st was 330 tables.
Each table requires 15 board feet of red cedar, which the company purchases for $4 per board foot. To protect against disruptions in production, management likes to keep enough cedar on hand at all times equal to 50% of the next month’s production needs. This requirement had been met on March 31st in that the company had 3,675 board feet of red cedar in the warehouse.
Purchases of lumber are paid for 50% at the time of purchase with the other 50% being paid the next month. All sales are on credit with 30% being collected in the month of sales, 50% being collected in the month following the month of sale and the remaining 20% being collected two months after the month of sale. JT has a tight credit policy and, as a result, does not have any bad debts.
Tables are hand crafted taking, on average, 5 hours to assemble. Employees are paid $16 per hour and never work overtime.
Manufacturing overhead includes all the costs of production other than the cedar and direct labour. The variable component is $25 per table manufactured and the fixed component is $32,000 per month. Fixed manufacturing overhead includes $12,000 of depreciation. Manufacturing overhead is applied to tables on the basis of tables manufactured.
JT’s monthly operating expenses are given below:
Variable:
Sales commissions $20 per table sold
Fixed:
Wages and salaries $19,000
Utilities 1,700
Insurance 1,500
Depreciation 2,100
Miscellaneous 2,200
All operating expenses are paid in the month for cash, with the exception of depreciation and insurance. Insurance is paid once a year in January ($18,000) then expensed over the entire year. The company plans to purchase some new manufacturing equipment in April for $26,000. JT declares a dividend of $5,000 on the last day of every quarter (i.e. March 31st, June 30th, September 30th and December 31st) and pays it one month later (i.e. the March dividend is paid April 30th, the June dividend is paid July 31st, etc.)
The balance sheet at March 31st is given below:
Assets
Cash $ 25,000
Accounts receivable 92,000
Inventory, red cedar lumber (raw materials) 14,700
Inventory, tables (finished goods) 82,500
Prepaid insurance 13,500
Fixed assets 270,000
Accumulated depreciation (162,000) 108,000
Total Assets 335,700
Liabilities and Shareholder’s Equity
Accounts payable, purchases 10,800
Dividends payable 5,000
Capital stock 15,000
Retained earnings 304,900
Total liabilities and shareholder’s equity 335,700
Management believes in keeping a minimum cash balance of $20,000 at the end of each month. The company can borrow from the bank at 12% annual interest. All borrowing must be done at the beginning of the month, and repayments must be done at the end of the month. Borrowings and repayments must also be in increments of $1,000. Interest is paid at the end of each quarter. Round all interest payments to the nearest whole dollar. The company wishes to use any excess cash to pay off the loan as rapidly as possible.
Required:
- Prepare a Sales Budget, Production Budget, Direct Materials Budget, Direct Labour Budget, Manufacturing Overhead Budget and Sales and Administration Budget.
- Prepare Schedules of Expected Cash Collections and Expected Cash Disbursements for Materials as well as a Cash Budget.
- Prepare a Budgeted Income Statement for the Quarter Ended June 30th.
- Prepare a Budgeted Balance Sheet at June 30th.
Solutions
Expert Solution
| Please give positive ratings so I can keep answering. It would help me a lot. Please comment if you have any query. Thanks! |
| Due to character limit I am attaching the image. |
| Just Tables | |||||||
| Sales Budget | February | March | April | May | June | Quarter | Note |
| Budgeted sales (Units) | 220.00 | 200.00 | 220.00 | 400.00 | 360.00 | 980.00 | A |
| Sell price | 500.00 | 500.00 | 500.00 | 500.00 | 500.00 | B | |
| Budgeted sales ($) | 110,000.00 | 100,000.00 | 110,000.00 | 200,000.00 | 180,000.00 | 490,000.00 | C=A*B |
| Production Budget | April | May | June | Total | July | August | Note |
| Budgeted sales (Units) | 220.00 | 400.00 | 360.00 | 980.00 | 320.00 | 390.00 | See A |
| Add: Closing | 600.00 | 540.00 | 480.00 | 480.00 | 585.00 | F=150% of A of next month. | |
| Less: Opening | 330.00 | 600.00 | 540.00 | 330.00 | 480.00 | G=150% of A of same month. For April its given in the problem. | |
| Production Budget | 490.00 | 340.00 | 300.00 | 1,130.00 | 425.00 | H | |
| Direct Material Budget | April | May | June | Total | July | Note |
| Production Budget | 490.00 | 340.00 | 300.00 | 1,130.00 | 425.00 | See H |
| Material required per unit | 15.00 | 15.00 | 15.00 | 15.00 | I | |
| Material Usage Budget | 7,350.00 | 5,100.00 | 4,500.00 | 16,950.00 | 6,375.00 | J=H*I |
| Add: Closing | 2,550.00 | 2,250.00 | 3,187.50 | 3,187.50 | F=50% of J of next month. | |
| Less: Opening | 3,675.00 | 2,550.00 | 2,250.00 | 3,675.00 | L=50% of J of same month. For April its given in the problem. | |
| Material Purchase Budget (Pound) | 6,225.00 | 4,800.00 | 5,437.50 | 16,462.50 | M | |
| Cost per board foot | 4.00 | 4.00 | 4.00 | N | ||
| Material Purchase Budget ($) | 24,900.00 | 19,200.00 | 21,750.00 | 65,850.00 | O=M*N |
| Direct Labor Budget | April | May | June | Total | Note |
| Production Budget | 490.00 | 340.00 | 300.00 | 1,130.00 | See H |
| Labor Hour required per unit | 5.00 | 5.00 | 5.00 | Q | |
| Labor Hour required | 2,450.00 | 1,700.00 | 1,500.00 | 5,650.00 | R=H*Q |
| Cost per Hour | 16.00 | 16.00 | 16.00 | S | |
| Direct Labor Budget | 39,200.00 | 27,200.00 | 24,000.00 | 90,400.00 | T=R*S |
| Manufacturing overhead Budget | |||||
| Variable manufacturing overhead Budget | April | May | June | Total | |
| Production Budget | 490.00 | 340.00 | 300.00 | 1,130.00 | See H |
| Variable manufacturing overhead per unit | 25.00 | 25.00 | 25.00 | U | |
| Variable manufacturing overhead Budget | 12,250.00 | 8,500.00 | 7,500.00 | 28,250.00 | V=H*U |
| Fixed manufacturing overhead | 32,000.00 |
<
 ekkarill92 answered 2 years agoRelated SolutionsYou were recently hired as an assistant controller at Just Tables (JT). JT sells one product,...You were recently hired as an assistant controller at Just
Tables (JT). JT sells one product, dining room tables made out of
red cedar. You have been charged with preparing a cash budget for
the second quarter (April to June) so that management can be aware
of any financing requirements. You have collected the following
information to assist you in preparation of the quarterly
budget:Recent and forecasted sales in units are as follows:
January
(actual)
140
February
(actual)
220
March...
You were recently hired as an assistant controller at Just Tables (JT). JT sells one product,...You were recently hired as an assistant controller at Just
Tables (JT). JT sells one product, dining room tables made out of
red cedar. You have been charged with preparing a cash budget for
the second quarter (April to June) so that management can be aware
of any financing requirements. You have collected the following
information to assist you in preparation of the quarterly
budget:
Recent and forecasted sales in units are as follows:
January
(actual)
140
February
(actual)
220...
You have recently been hired as the assistant controller for Stanton Industries. Your immediate superior is...You have recently been hired as the assistant controller
for Stanton Industries. Your immediate superior is the controller
who, in turn, reports to the vice president of
finance.
The controller has assigned you the task of preparing
the year-end adjustments. For receivables, you have prepared an
aging of accounts receivable and have applied historical
percentages to the balances of each of the age categories. The
analysis indicates that an appropriate balance for Allowance for
Uncollectible Accounts is $180,000. The existing...
You have recently been hired as the assistant controller for Stub Industries, a large publicly held...You have recently been hired as the assistant controller for
Stub Industries, a large publicly held manufacturing company. Your
immediate superior is the controller who, in turn, is responsible
to the VP of Finance.
The controller has assigned you the task of preparing the
year-end adjusting entries. In the receivable area, you have
prepared an aging of accounts receivable and have applied
historical percentages to the balances of each of the age
categories. The analysis indicates that an appropriate balance...
You have recently been hired as the assistant controller for Stanton Industries, a large, publicly held...You have recently been hired as the assistant controller for
Stanton Industries, a large, publicly held manufacturing company.
Your immediate superior is the controller who, in turn, is
responsible to the vice president of finance. The controller has
assigned you the task of preparing the year-end adjusting entries.
In the receivables area, you have prepared an aging of accounts
receivable and have applied historical percentages to the balances
of each of the age categories. The analysis indicates that an
appropriate...
You have been recently hired as an assistant controller for XYZ Industries, a large, publically held...You have been recently hired as an assistant controller for XYZ
Industries, a large, publically held manufacturing company. Your
immediate supervisor is the controller who also reports directly to
the VP of Finance. The controller has assigned you the task of
preparing the year-end adjusting entries. In the receivables area,
you have prepared an aging accounts receivable and have applied
historical percentages to the balances of each of the age
categories. The analysis indicates that an appropriate estimated
balance for...
Accounting ethics cases You have recently been hired as the assistant controller for Stanton Temperton Corporation,...Accounting ethics cases
You have recently been hired as the assistant controller for
Stanton Temperton Corporation, which rents building space in major
metropolitan areas. Customers are required to pay six months of
rent in advance. At the end of 2018, the company's president, Jim
Temperton, notices that net income has fallen compared to last
year. In 2017, the company reported before-tax profit of $330,000,
but in 2018 the before-tax profit is only $280,000. This concerns
Jim for two reasons. First,...
You have recently been hired as the assistant controller for Stanton Temperton Corporation, which rents building...You have recently been hired as the assistant controller for
Stanton Temperton Corporation, which rents building space in major
metropolitan areas. Customers are required to pay six months of
rent in advance. At the end of 2018, the company's president, Jim
Temperton, notices that net income has fallen compared to last
year. In 2017, the company reported before-tax profit of $330,000,
but in 2018 the before-tax profit is only $280,000. This concerns
Jim for two reasons. First, his year-end bonus...
You have recently been hired as the assistant controller for Stanton Temperton Corporation, which rents building...You have recently been hired as the assistant controller for
Stanton Temperton Corporation, which rents building space in major
metropolitan areas. Customers are required to pay six months of
rent in advance. At the end of 2018, the company's president, Jim
Temperton, notices that net income has fallen compared to last
year. In 2017, the company reported before-tax profit of $330,000,
but in 2018 the before-tax profit is only $280,000. This concerns
Jim for two reasons. First, his year-end bonus...
Assume that you were recently hired as assistant to Jerry Lehman, financial VP of Coleman Technologies....Assume that you were recently hired as assistant to Jerry
Lehman, financial VP of Coleman Technologies. Your first task is to
estimate Coleman’s cost of capital. Lehman has provided you with
the following data, which he believes is relevant to your task:
The firm’s marginal tax rate is 40%.
The current price of Coleman’s 12 % coupon, semiannual payment,
noncallable bonds with 15 years remaining to maturity is $1,153.72.
New bonds would be privately placed with no flotation cost.
The...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
ADVERTISEMENT
|