Wright Lighting Fixtures forecasts its sales in units for the next four months as follows:

March

4,000

April

10,000

May

8,000

June

6,000

Wright maintains an ending inventory for each month in the amount of one and one-half times the expected sales in the following month. The ending inventory for February (March’s beginning inventory) reflects this policy. Materials cost \(7 per unit and are paid for in the month after production. Labor cost is \)3 per unit and is paid for in the month incurred. Fixed overhead is \(10,000 per month. Dividends of \)14,000 are to be paid in May. Eight thousand units were produced in February.

Complete a production schedule and a summary of cash payments for

March, April, and May. Remember that production in any one month is equal to

sales plus desired ending inventory minus beginning inventory.

Short Answer

Expert verified

Production schedule

March

April

May

June

Forecasted unit sales

4,000

10,000

8,000

6,000

Add: Desired ending inventory

15,000

12,000

9,000

Less: Beginning inventory

6,000

15,000

12,000

Units to be produced

13,000

7,000

5,000

Summary of cash payments

February

March

April

May

Units produced

8,000

13,000

7,000

5,000

Material cost paid month after production @($7 per unit)

$56,000

$91,000

$49,000

Labor cost @3 per unit

39,000

21,000

15,000

Fixed overheads

10,000

10,000

10,000

Dividends

14,000

Total cash payment

105,000

122,000

88,000

Step by step solution

01

Desired ending inventory of march

Endinginventoryofmarch=Forecastedsalesofapril+12offorecastedsalesofapril=$10,000+12×$10,000=$15,000

02

Desired ending inventory of april

Endinginventoryofapril=Forecastedsaleofmay+12offorecastedsalesofmay=$8,000+12×$8,000=$12,000

03

Desired ending inventory of may

Endinginventoryofmay=Forecastedsalesofjune+12offorecastedsalesofjune=$6,000+12×$6,000=$9,000

04

Beginning inventory of march

Beginninginventoryofmarch=Forecastedsalesofmarch+12offorecastedsalesofmarch=$4,000+12×$4,000=$6,000

Unlock Step-by-Step Solutions & Ace Your Exams!

  • Full Textbook Solutions

    Get detailed explanations and key concepts

  • Unlimited Al creation

    Al flashcards, explanations, exams and more...

  • Ads-free access

    To over 500 millions flashcards

  • Money-back guarantee

    We refund you if you fail your exam.

Over 30 million students worldwide already upgrade their learning with Vaia!

One App. One Place for Learning.

All the tools & learning materials you need for study success - in one app.

Get started for free

Most popular questions from this chapter

The balance sheet for Stud Clothiers is shown below. Sales for the year were \(2,400,000, with 90 percent of sales sold on credit.

Stud Clothier

Balance sheet 20X1

Assets

Liabilities and Equity

Cash

\)60,000

Account payable

\(220,000

Account receivable

240,000

Accrued taxes

30,000

Inventory

350,000

Bonds payable (long term)

150,000

Plant and equipment

410,000

Common stock

80,000

Paid in capital

200,000

Retained earnings

380,000

Total assets

\)1,060,000

Total LIbilities and Equity

$1,060,000

Compute the following:

e. Average collection period.

The balance sheet for Stud Clothiers is shown below. Sales for the year were \(2,400,000, with 90 percent of sales sold on credit.

Stud Clothier

Balance sheet 20X1

Assets

Liabilities and Equity

Cash

\)60,000

Account payable

\(220,000

Account receivable

240,000

Accrued taxes

30,000

Inventory

350,000

Bonds payable (long term)

150,000

Plant and equipment

410,000

Common stock

80,000

Paid in capital

200,000

Retained earnings

380,000

Total assets

\)1,060,000

Total LIbilities and Equity

$1,060,000

Compute the following:

d. Assets turnover ratio.

Polly Esther Dress Shops Inc. can open a new store that will do an annual sales volume of $837,900. It will turn over its assets 1.9 times per year. The profit margin on sales will be 8 percent. What would net income and return on assets (investment) be for the year?

Landers Nursery and Garden Stores has current assets of \(220,000 and fixed assets of \)170,000. Current liabilities are \(80,000 and long-term liabilities are \)140,000. There is $40,000 in preferred stock outstanding and the firm has

issued 25,000 shares of common stock. Compute book value (net worth)

per share.

Lemon Auto Wholesalers had sales of \(1,000,000 last year, and cost of goods sold represented 78 percent of sales. Selling and administrative expenses were 12 percent of sales. Depreciation expense was \)11,000 and interest expense for the year was \(8,000. The firm’s tax rate is 30 percent.

a. Compute earnings after taxes.

b. Assume the firm hires Ms. Carr, an efficiency expert, as a consultant. She suggests that by increasing selling and administrative expenses to 14 percent of sales, sales can be increased to \)1,050,900. The extra sales effort will also reduce cost of goods sold to 74 percent of sales. (There will be a larger markup in prices as a result of more aggressive selling.) Depreciation expense will remain at \(11,000. However, more automobiles will have to be carried in inventory to satisfy customers, and interest expense will go up to \)15,800. The firm’s tax rate will remain at 30 percent. Compute revised earnings after taxes based on Ms. Carr’s suggestions for Lemon Auto Wholesalers. Will her ideas increase or decrease profitability?

See all solutions

Recommended explanations on Business Studies Textbooks

View all explanations

What do you think about this solution?

We value your feedback to improve our textbook solutions.

Study anywhere. Anytime. Across all devices.

Sign-up for free