Sales and Production Budget II You have been assigned to prepare the cash budget, which is one portion of the master budget for Marble Company. According to a credit agreement with the company’s bank, Marble Company promises to have a minimum cash balance of $65,000 at each month-end. In return, the bank has agreed that the company can borrow up to $175,000 at a monthly interest rate of 2%, paid on the last day of each month. The interest is computed based on the beginning balance of the loan for the month. The company repays loan principal with any cash in excess of $40,000 on the last day of each month. The company has a cash balance of $60,000 and a loan balance of $125,000 at January 1. Marble Co. budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments (excluding cash payments for loan principal and interest payments) for the first three months of next year.
|
Cash Receipts |
Cash Payments |
|
|
January |
$600,000 |
$450,000 |
|
February |
$475,000 |
$330,000 |
|
March |
$450,000 |
$525,000 |
|
Cash Receipts |
Cash Payments |
|
|
January February March |
$500,000 $475,000 $500,000 |
$450,000 $375,000 $525,000 |
In: Accounting
Shaker Stairs Co. designs and builds factory-made premium wooden stairways for homes. The manufactured stairway components (spindles, risers, hangers, hand rails) permit installation of stairways of varying lengths and widths. All are of white oak wood. Budgeted manufacturing overhead costs for the year 2017 are as follows.
|
Overhead Cost Pools |
Amount |
|
| Purchasing |
$73,800 |
|
| Handling materials |
82,080 |
|
| Production (cutting, milling, finishing) |
211,000 |
|
| Setting up machines |
96,250 |
|
| Inspecting |
96,000 |
|
| Inventory control (raw materials and finished goods) |
127,680 |
|
| Utilities |
270,000 |
|
| Total budgeted overhead costs |
$956,810 |
For the last 4 years, Shaker Stairs Co. has been charging overhead
to products on the basis of machine hours. For the year 2017,
100,000 machine hours are budgeted.
Jeremy Nolan, owner-manager of Shaker Stairs Co., recently directed
his accountant, Bill Seagren, to implement the activity-based
costing system that he has repeatedly proposed. At Jeremy Nolan’s
request, Bill and the production foreman identify the following
cost drivers and their usage for the previously budgeted overhead
cost pools.
|
Activity Cost Pools |
Cost Drivers |
Expected Use of |
||
| Purchasing | Number of orders | 600 | ||
| Handling materials | Number of moves | 8,000 | ||
| Production (cutting, milling, finishing) | Direct labor hours | 100,000 | ||
| Setting up machines | Number of setups | 1,250 | ||
| Inspecting | Number of inspections | 6,000 | ||
| Inventory control (raw materials and finished goods) | Number of components | 168,000 | ||
| Utilities | Square feet occupied | 90,000 |
Steve Hannon, sales manager, has received an order for 250
stairways from Community Builders, Inc., a large housing
development contractor. At Steve’s request, Bill prepares cost
estimates for producing components for 250 stairways so Steve can
submit a contract price per stairway to Community Builders. He
accumulates the following data for the production of 250
stairways.
| Direct materials | $103,700 | |
| Direct labor | $112,100 | |
| Machine hours | 14,600 | |
| Direct labor hours | 5,100 | |
| Number of purchase orders | 60 | |
| Number of material moves | 800 | |
| Number of machine setups | 100 | |
| Number of inspections | 450 | |
| Number of components | 16,000 | |
| Number of square feet occupied | 8,000 |
Correct answer iconYour answer is correct.
Compute the predetermined overhead rate using traditional costing with machine hours as the basis. (Round answer to 2 decimal places, e.g. 12.25.)
| Predetermined overhead rate |
$ |
per machine hour |
Correct answer iconYour answer is correct.
What is the manufacturing cost per stairway under traditional costing? (Round answer to 2 decimal places, e.g. 12.25.)
| Cost per stairway |
$ |
Correct answer iconYour answer is correct.
Calculate activity-based overhead rate for each activity. (Round answers to 2 decimal places, e.g. 12.25.)
|
Activity |
Overhead Rate |
||
| Purchasing |
$ |
per order | |
| Handling materials |
$ |
per move | |
| Production |
$ |
per D/L hour | |
| Setting up machines |
$ |
per setup | |
| Inspecting |
$ |
per inspection | |
| Inventory control |
$ |
per component | |
| Utilities |
$ |
per sq. ft. | |
Incorrect answer iconYour answer is incorrect.
Caluclate total overhead assigned under ABC.
| Total overhead assigned |
$ |
eTextbook and Media
Incorrect answer iconYour answer is incorrect.
What is the manufacturing cost per stairway under the proposed activity-based costing? (Round answer to 2 decimal places, e.g. 12.25.)
| Total cost per stairway |
$ |
In: Accounting
7. What are some potential opportunities you might recognise associated with introducing cloud computing?
In: Accounting
On July 1, MTC Wholesalers had a cash balance of $245,000 and accounts payable of $138,600. Actual sales for May and June, and budgeted sales for July, August, September, and October are:
| Month | Actual Sales | Month | Budgeted Sales |
|---|---|---|---|
| May | $210,000 | July | $ 126,000 |
| June | 224,000 | August | 112,000 |
| September | 140,000 | ||
| October | 168,000 |
All sales are on credit with 75 percent collected during the month of sale, 20 percent collected during the next month, and 5 percent collected during the second month following the month of sale. Cost of goods sold averages 70 percent of sales revenue. Ending inventory is one-half of the next month's predicted cost of sales. The other half of the merchandise is acquired during the month of sale. All purchases are paid for in the month after purchase. Operating costs are estimated at $39,200 each month and are paid during the month incurred.
Required
Prepare purchases and cash budgets for July, August, and
September.
Do not use a negative sign with your answers.
| MTC Wholesalers | ||||
|---|---|---|---|---|
| Purchases Budget | ||||
| For the Months of July, August, and September | ||||
| July | August | September | ||
| Inventory required, current sales | $Answer | $Answer | $Answer | |
| Desired ending inventory | Answer | Answer | Answer | |
| Total inventory needs | Answer | Answer | Answer | |
| Less beginning inventory | Answer | Answer | Answer | |
| Purchases | $Answer | $Answer | $Answer | |
Do not use a negative sign with your answers.
| MTC Wholesalers | ||||
|---|---|---|---|---|
| Cash Budget | ||||
| For the Months of July, August, and September | ||||
| July | August | September | ||
| Cash balance, beginning | $Answer | $Answer | $Answer | |
| Cash receipts | ||||
| Current month's sales | Answer | Answer | Answer | |
| Previous month's sales | Answer | Answer | Answer | |
| Sales two months prior | Answer | Answer | Answer | |
| Total receipts | Answer | Answer | Answer | |
| Cash available | Answer | Answer | Answer | |
| Cash disbursements: | ||||
| Purchases | Answer | Answer | Answer | |
| Operating costs | Answer | Answer | Answer | |
| Total disbursements | Answer | Answer | Answer | |
| Cash balance, ending | $Answer | $Answer | $Answer | |
In: Accounting
5. Direct labor variances - Find the missing information:
|
Case A |
Case B |
Case C |
|
|
Units Produced |
800 |
240 |
1,500 |
|
Standard hours per unit |
3 |
? (d) |
? (g) |
|
Standard hours (SQA) |
? (a) |
480 |
? (h) |
|
Standard rate per hour |
$7.00 |
$9.50 |
$6.00 |
|
Actual hours worked |
2,330 |
? (e) |
4,000 |
|
Actual total labor cost |
? (b) |
$4,560 |
$26,812.50 |
|
Labor rate (price) variance |
$466 F |
$288 U |
? (i) |
|
Labor efficiency (usage) variance |
? (c) |
(f) |
$2,250 U |
|
Letter |
Your answer |
Letter |
Your answer |
|
A |
F |
||
|
B |
G |
||
|
C |
H |
||
|
D |
I |
||
|
E |
6. Chuck makes Supersized Chucky-Puffs. Chuck determined the standards for each unit (bag) of Chucky-Puff produced requires 1.5 gallons of ingredients (direct materials) and 0.75 direct labor hours. Chuck expects to pay $2 per gallon of ingredients and his employees a rate of $10 per hour. Based on the company’s forecasts, Chuck is expecting to sell 15,000 units (bags) during the year. At the end of year, Chuck actually sold 16,000 units (bags) and used 20,000 gallons of ingredients and paid $1.9 per gallon. Further, Human resources informed Chuck that he incurred $80,000 in direct labor costs from 10,000 direct labor hours (assume no overtime is used).
a. What is the material price variance?
b. What is the material quantity variance?
c.What is the labor rate variance?
d. What is the labor usage variance?
7. Responsibility Accounting:
a. What is a cost center? Give an example of a cost center ____________________________________________________________________________________________________________________________________________________________
b. What is a Profit center? Give an example of a profit center ____________________________________________________________________________________________________________________________________________________________
c. What is an investment center? Give an example of an investment center ____________________________________________________________________________________________________________________________________________________________
d. What is management by exception: __________________________________________________________________________________________________________________________________________________________________________
e. The Mega Division of Green Corporation is an investment center. It has $1,000,000 of operating assets. During 2018, the Mega Division earned operating income of $300,000 on $6,000,000 of sales. Green’s companywide return on investment or desired rate of return is approximately 10% SHOW WORK FOR CREDIT!
In: Accounting
10. Why should you prioritise the introduction of cloud computing?
In: Accounting
FUTURE OF REVENUE RECOGNITION
I. Do the new standards increase comparability across industries and capital
markets?
II. Do the new standards provide better disclosure, so investors and other
users of financial statements better understand the economics behind the
numbers?
III. Possibility of Fraud with new FASB standards
In: Accounting
Direct Materials Variances Bellingham Company produces a product that requires 8 standard pounds per unit. The standard price is $5.5 per pound. If 3,400 units required 26,700 pounds, which were purchased at $5.66 per pound, what is the direct materials (a) price variance, (b) quantity variance, and (c) total direct materials cost variance? Enter a favorable variance as a negative number using a minus sign and an unfavorable variance as a positive number.
In: Accounting
Dawes, Vickerman, and Wrester are liquidating their partnership. Before selling the assets and paying the liabilities, the capital balances are Dawes $46,000; Vickerman, $25,000; and Wrester, $23,000. The profit-and-loss-sharing ratio has been 3:1:1 for Dawes, Vickerman, and Wrester, respectively. The partnership has $84,000 cash, $ 41,000 non-cash assets, and $31,000 accounts payable.
Requirements:
1. Assuming the partnership sells the non-cash assets for $45,000, record the journal entries for the sale of non-cash assets, allocation of gain or loss on liquidation, the payment of the outstanding liabilities, and the distribution of remaining cash to partners. (Record debits first, then credits. Select the explanation on the last line of the journal entry table.)
-Journalize the sale of the non-cash assets for $45,000.
-Journalize the allocation of the gain or loss to the partners' capital accounts.
-Journalize the payment of the liabilities.
-Journalize the distribution of remaining cash to the partners.
2. Assuming the partnership sells the non-cash assets for $19,000, record the journal entries for the sale of non-cash assets, allocation of gain or loss on liquidation, the payment of the outstanding liabilities, and the distribution of remaining cash to partners. (Record debits first, then credits. Select the explanation on the last line of the journal entry table.)
-Journalize the sale of the non-cash assets for $19,000.
-Journalize the allocation of the gain or loss to the partners' capital accounts.
-Journalize the payment of the liabilities.
-Journalize the distribution of remaining cash to the partners.
In: Accounting
Statement of cash flows
Natasha Bush operates Natasha’s Cafe as a sole trader. Although she is not legally required to, she wants to prepare a statement of cash flows for her business from the following ledger account balances as at 31 March 2019 and 31 March 2018:
|
$ |
$ |
|
|
2019 |
2018 |
|
|
Cash at bank |
21,125 |
24,100 |
|
Accounts receivable |
7,700 |
8,000 |
|
Inventory |
21,300 |
18,000 |
|
Prepaid expenses |
600 |
1,100 |
|
Term deposit |
10,000 |
20,000 |
|
Shop equipment |
27,000 |
25,000 |
|
Accumulated depreciation – Equipment |
16,500 |
14,600 |
|
Delivery van |
40,000 |
30,000 |
|
Accumulated depreciation – Van |
4,000 |
10,000 |
|
Accounts payable (for purchases) |
8,400 |
6,000 |
|
Accrued wages |
1,800 |
1,400 |
|
Accrued expenses |
2,800 |
2,000 |
|
Loan – ASB |
45,000 |
10,000 |
|
Owner's equity |
82,200 |
82,200 |
|
Drawings |
62,850 |
|
|
Sales income |
225,000 |
|
|
Loss on the sale of delivery van |
200 |
|
|
Loss on the sale of shop equipment |
300 |
|
|
Interest received |
600 |
|
|
Cost of goods sold |
79,400 |
|
|
Other expenses |
37,225 |
|
|
Wages and salaries expense |
76,200 |
|
|
Interest expense |
2,400 |
Additional information
Tasks
In: Accounting
If a company excluded the tax refund from taxable income, and did not record an unrecognized tax benefit, what must the company believe about whether the IRS and tax courts will challenge and allow this exclusion? Explain using the language of FIN 48.
In: Accounting
Preble Company manufactures one product. Its variable manufacturing overhead is applied to production based on direct labor-hours and its standard cost card per unit is as follows:
| Direct material: 6 pounds at $8.00 per pound | $ | 48.00 |
| Direct labor: 3 hours at $14 per hour | 42.00 | |
| Variable overhead: 3 hours at $5 per hour | 15.00 | |
| Total standard variable cost per unit | $ | 105.00 |
The company also established the following cost formulas for its selling expenses:
| Fixed Cost per Month | Variable Cost per Unit Sold | ||||||
| Advertising | $ | 250,000 | |||||
| Sales salaries and commissions | $ | 200,000 | $ | 17.00 | |||
| Shipping expenses | $ | 8.00 | |||||
The planning budget for March was based on producing and selling 19,000 units. However, during March the company actually produced and sold 24,000 units and incurred the following costs:
Direct-laborers worked 60,000 hours at a rate of $15.00 per hour.
Total variable manufacturing overhead for the month was $336,600.
Total advertising, sales salaries and commissions, and shipping expenses were $260,000, $480,000, and $165,000, respectively.
1. What raw materials cost would be included in the company’s flexible budget for March?
2. What is the materials quantity variance for March? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance.). Input the amount as a positive value.)
3. What is the materials price variance for March? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance.). Input the amount as a positive value.)
4. If Preble had purchased 175,000 pounds of materials at $7.20 per pound and used 160,000 pounds in production, what would be the materials quantity variance for March? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance.). Input the amount as a positive value.)
5. If Preble had purchased 175,000 pounds of materials at $7.20 per pound and used 160,000 pounds in production, what would be the materials price variance for March? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance.). Input the amount as a positive value.)
7. What is the direct labor efficiency variance for March? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance.). Input the amount as a positive value.)
8. What is the direct labor rate variance for March?
(Indicate the effect of each variance by selecting "F" for
favorable, "U" for unfavorable, and "None" for no effect (i.e.,
zero variance.). Input the amount as a positive
value.)
In: Accounting
he following information is available for Sage Hill, Inc. for
the year 2017.
| Administrative expense | ||
| Officers' salaries | $11,000 | |
| Depreciation of office furniture and equipment | 8,400 | |
| Cost of goods sold | 121,520 | |
| Rent revenue | 2,500 | |
| Selling expense | ||
| Delivery expense | 4,400 | |
| Sales commissions | 16,970 | |
| Depreciation of sales equipment | 13,200 | |
| Sales revenue | 231,000 | |
| Income tax | 12,370 | |
| Interest expense | 3,460 |
Common shares outstanding for 2017 total 23,000 (000 omitted).
Prepare an income statement for Sage Hill Inc. for the year 2017 using the multiple-step form. (Round earnings per share to 2 decimal places, e.g. 1.48.)
In: Accounting
The year has passed and Ron has become used to being able to come to you with more and more complex finance and accounting questions about this Ukrainian Division. He has come into your office in the middle of November of the following year. Your projects are going quite well as he has a new task for you. He’s been reviewing the operations of the Ukrainian plant and has some questions about the Income Statement. The plant appears to be much more profitable than the other bottling plants within the company and he’s wondering about implementing some of the practices that he has seen there into Canadian Bottling sites. He has provided you with the Income Statement that the Canadian finance team has provided him and wants some key pieces of information from you.
|
Ukrainian Bottling Company Inc. |
||
|
Income Statement |
||
|
For the Year Ended October 31st, XXXX |
||
|
Revenue |
$650,000.00 |
|
|
Cost of Goods Sold |
||
|
Labour |
$75,000.00 |
|
|
Material |
$50,000.00 |
|
|
Total Cost of Goods Sold |
$125,000.00 |
|
|
Gross Profit |
$525,000.00 |
|
|
Expenses |
||
|
Packaging Labour |
$67,000.00 |
|
|
Electricity |
$14,000.00 |
|
|
Amortization |
$32,000.00 |
|
|
Rent |
$15,000.00 |
|
|
Shipping |
$160,000.00 |
|
|
Total Expenses |
$288,000.00 |
|
|
Net Income |
$237,000.00 |
|
An executive summary of their financial position has been provided by the Ukrainian Management team; all of this information appears to be useful to them but, only some is relevant to you. Highlights of the financial figures are as follows:
|
Current number of unit produced: |
12,000 |
|
Number of Employees on Staff: |
521 |
|
Original cost of Smelting Machinery: |
$85,000 |
|
Number of Shares Outstanding: |
125,000 |
|
Trading Price per Share: |
$12 |
Required:
In: Accounting
J&J, Inc., manufactures two products that it sells to the same market. Excerpted below are its budgeted and actual operating results for the year just completed:
| Budget | Actual | ||
| Unit sales | |||
| Product X | 31,500 | 78,000 | |
| Product Y | 81,000 | 44,000 | |
| Unit contribution margin | |||
| Product X | $ | 4.8 | 3.9 |
| Product Y | $ | 13 | 14 |
| Unit selling price | |||
| Product X | $ | 13 | 14 |
| Product Y | $ | 30 | 29 |
Industry volume was estimated to be 1,425,000 units at the time the budget was prepared. Actual industry volume for the period was 1,720,000 units. J&J measures variances using contribution margin. The market share variance is: (Round percentage answers to nearest whole percent and other values to 2 decimal places.)
|
$75,400 unfavorable. |
|
$91,990 unfavorable. |
|
$171,900 unfavorable. |
|
$184,040 unfavorable. |
|
$224,700 unfavorable. |
In: Accounting