Questions
Sales and Production Budget II You have been assigned to prepare the cash budget, which is...

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

  1. Prepare monthly cash budgets for January, February, and March. (Negative balances and Loan repayment amounts (if any) should be indicated should be indicated in parentheses “( )”.)
  2. If the cash receipts and payments changed to the values shown in the table below, how would the budget change?
  3. Cash Receipts

    Cash Payments

    January

    February

    March          

    $500,000   

    $475,000

    $500,000  

    $450,000

    $375,000

    $525,000

  4. Write a business letter to the CEO analyzing the cash budgets of this company and state your recommendations based on the initial cash receipts and cash payments and on the cash receipts and cash payments changes.

In: Accounting

Shaker Stairs Co. designs and builds factory-made premium wooden stairways for homes. The manufactured stairway components...

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
Cost Drivers

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?

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....

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...

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!

  1. What is the ROI?______________________

  1. What is the margin? ____________________

  1. What is the turnover? _____________________

  1. What is the residual income? _______________

In: Accounting

10. Why should you prioritise the introduction of cloud computing?

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?...

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...

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,...

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...

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

  • During the year shop equipment that had cost $5,000 and accumulated depreciation of $3,200 was sold for $1,500. New equipment was purchased.
  • During the current financial period, Natasha sold the cafe’s delivery van for $19,800. A new, more economical, hybrid van was purchased for $40,000.
  • Other expenses includes depreciation expense.
  • You are not required to account for taxes.

Tasks

  1. Give two reasons why you think Natasha wants to prepare a statement of cash flows.
  2. Using the information provided, prepare a statement of cash flows for the year ended 31 March 2019.
  3. Discuss whether or not you think Natasha would be happy with what the cash flow statement shows her about her business.

In: Accounting

If a company excluded the tax refund from taxable income, and did not record an unrecognized...

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...

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:

  1. Purchased 160,000 pounds of raw materials at a cost of $7.20 per pound. All of this material was used in production.
  2. Direct-laborers worked 60,000 hours at a rate of $15.00 per hour.

  3. Total variable manufacturing overhead for the month was $336,600.

  4. 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'...

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...

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:

  1. Identify all the expenses above as being either Fixed or Variable. For expenses labeled Shipping, Amortization and Electricity, explain why you chose either fixed or variable.
  2. Using your cost behaviour breakdown, calculate the Contribution Margin for each unit produced.
  3. What would be the number of units necessary to produce for a breakeven scenario? (5Marks)
  4. Management has recently discovered that they are now able to lower their labour costs from 67,000 to 55,000 within the year with all other costs remaining the same. What is the Contribution Margin now?
  5. Calculate the Gross Profit Margin and Net Profit Margin Ratios. (4 Marks

In: Accounting

J&J, Inc., manufactures two products that it sells to the same market. Excerpted below are its...

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