The income statement for the Stylo Company for the past year is:   Sales (150000 units @ $30) $4,500,000 Cost of Goods Sold:   Materials $1,050,000 Labour 1,500,000 Variable FOH 450,000 Fixed FOH 500,000           3,500,000 Gross Profit $1,000,000 Variable Marketing Expenses $ 135,000 Fixed Marketing Expenses 185,000 Fixed Administrative Expenses   180,000                             500,000 Income before Tax $ 500,000 Income Tax     250,000 Net Inco me   $ 250,000   Woodstock is preparing its budget for the coming year and has made the following predictions about cost increases: material 5%, labour 8%, all other costs including fixed 6%. Productive capacity is 200,000 units. The president has been offered various proposals by the division managers as follows: Maintain the present volume and sales price Produce and sell at capacity and reduce the unit price $28. Raise the unit price to $32, spend an extra # 300,000 on advertising, and produce and sell 180,000 un   Required: Recommended action, based on quantification of alternatives

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question

 

Q # 1: The income statement for the Stylo Company for the past year is:

 

Sales (150000 units @ $30)

$4,500,000

Cost of Goods Sold:

 

Materials

$1,050,000

Labour

1,500,000

Variable FOH

450,000

Fixed FOH

500,000           3,500,000

Gross Profit

$1,000,000

Variable Marketing Expenses

$ 135,000

Fixed Marketing Expenses

185,000

Fixed Administrative Expenses

  180,000                             500,000

Income before Tax

$ 500,000

Income Tax

    250,000

Net Inco me

  $ 250,000

 

Woodstock is preparing its budget for the coming year and has made the following predictions about cost increases: material 5%, labour

8%, all other costs including fixed 6%. Productive capacity is 200,000 units.

The president has been offered various proposals by the division managers as follows:

  • Maintain the present volume and sales price
  • Produce and sell at capacity and reduce the unit price $28.
  • Raise the unit price to $32, spend an extra # 300,000 on advertising, and produce and sell 180,000 un

 

Required:

Recommended action, based on quantification of alternatives

 

Q # 2: The Redman Company manufacturers a product whose standard unit cost is as follows:

 

Direct Materials: 24kg @ $3.00............................ $ 72.00

Direct Labour: 6 hours @ $6.50.............................. 39.00

Factory overhead: 6 hours @ $0.75........................... 4.50

Total unit standard cost...................................... $ 115.50

The factory overhead was based on the following flexible budget, in which 90% is normal capacity.

80%

90%

100%

Hours (direct labour).................................. 40,000

45,000

50,000

Variable expenses.................................. $20,000

$22,500

$25,000

 

 

 

Actual data for November:

 

Fixed Expenses..................................... 11,250          11,250         11,250

Total Factory Overheads........................ 31,250          33,750         36,250

 

Planned production, 7,500 units

Material put into production 192410kg @ $ 3.04 (average cost) Direct Labour 46,830 hours @ $6.60 average labour cost Actual FOH $ 36,340

Other data:

Beginning inventory, work in process, 80 units, all material, 50% converted Ending inventory, work in process, 100 units, all material, 50% converted Started in process during November 7,850 units

 

Required:

A variance analysis of

  • Material (Overall, Price and Usage)
  • FOH (Overall, Spending and Capacity)

 

Q # 3:

Steel Craft Manufactures and sells a seasonal product that has peak sales in the third quarter. The following information concerns operations for Year 2—the coming year—and for the first two quarters of Year 3:

 

Year 2 Quarter

Year 3 Quarter

1

2

3

4

5

6

Budgeted unit Sales

50000

70000

110000

60000

80000

90000

 

Sales are collected in the following pattern: 60% in the quarter the sales are made, and the remaining 20% & 20% in the following quarter. On January 1, Year 2, the company’s balance sheet showed $75,000 in accounts receivable, all of which will be collected in the first quarter of the year. Bad debts are negligible and can be ignored.

 

The company desires an ending finished goods inventory at the end of each quarter equal to 35% of the budgeted unit sales for the next quarter. On December 31, Year 1, the company had 22,000 units on hand.

 

Five pounds of raw materials are required to complete one unit of product. The company requires ending raw materials inventory at the end of each quarter equal to 10% of the following quarter’s production needs. On December 31, Year 1, the company had 23,000 pounds of raw materials on hand.

 

The raw material costs $0.75 per pound. Raw material purchases are paid for in the following pattern: 55% paid in the quarter the purchases are made, and the remaining 45% paid in the following quarter. On January 1, Year 2, the company’s balance sheet showed $71,500 in accounts payable for raw material purchases, all of which will be paid for in the first two quarter (50% in each quarter) of the year.

 

Required:

Prepare the following budgets and schedules for the year, showing both quarterly and total figures:

  • A sales budget and a schedule of expected cash collections
  • A production
  • A direct materials budget and a schedule of expected cash payments for purchases of material.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 3 images

Blurred answer
Knowledge Booster
Divisional performance management
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education