المحاسب الإداري المعتمد الجزء 1 B. Planning, Budgeting and Forecasting

LumenQuay: When Capacity Drives the Forecast

LumenQuay Marine Lighting

Questions: 7 Answered:

Opens full screen, like the exam.

Question of 7 LumenQuay: When Capacity Drives the Forecast

LumenQuay: When Capacity Drives the Forecast Case-based question

The case

LumenQuay Marine Lighting makes navigation-light kits sold through marine-equipment distributors. After commissioning an automated assembly cell, executives used its 18,000-unit annual output capability as the production target. Finance then imposed an 18,000-unit sales target without consulting the distributor account teams. After that target was approved, a required export certification was delayed. During the year, sales reached only 14,200 units, while production remained at 18,000 units. Opening finished-goods inventory was 900 units and management's intended year-end inventory target was 1,100 units.

The year-end inventory review also identified 750 kits of an older design. Their recorded unit cost is $48, but estimated selling price is only $35 and the additional cost necessary to sell each kit is $5.

Management now wants a coordinated sales and production plan with meaningful operational input. For the improved planning exercise in Question 3, use forecast sales of 14,200 units and the same opening and desired ending inventories.

Assumptions

Production and sales refer to complete saleable kits, with no spoilage, returns or work in process.
Use lower of cost and net realizable value for the older kits under US GAAP; the inventory is measured using FIFO or average cost, not LIFO or the retail method.
Net realizable value equals expected selling price less costs necessary to sell; no additional completion costs are required.
Question 7 asks for units above the intended ending-inventory target, not total physical ending inventory. The six-event ordering question follows the explicit case chronology.

Select THREE financial consequences that LumenQuay should consider when evaluating its excess stock.

Select 3 answers. Selected 0 / 3

Answer The excess kits can be recognized as revenue at year-end because they are complete and available for shipment. Funds remain committed to stock instead of being available for other operating needs. Older designs may require a write-down when recoverable selling value falls below cost. Producing beyond demand reduces the working capital to be financed, because finished goods are a current asset. Additional storage, insurance or handling costs may arise while the stock is held.

What is the central planning error in LumenQuay's original approach, and what should replace it?

Answer It treated productive capability as evidence of demand; it should first develop a supported sales forecast and then derive production using inventory targets. It let finance rather than operations set the targets; the production manager should set both sales and production from the cell's capability. It used a static budget; a flexible budget built on the 18,000-unit capability would have prevented the excess stock. It did not anticipate the certification delay; the next plan should keep the 18,000-unit target and add a reserve for regulatory risk.

Under the improved plan, how many kits should LumenQuay produce for forecast sales of 14,200 units, desired ending inventory of 1,100 and opening inventory of 900? Enter a positive whole number of units; no rounding is necessary.

Answer units

A whole number.

What total write-down is required for the 750 older-design kits? Enter a positive whole-dollar expense amount; no rounding is necessary.

Answer USD

A whole number.

Arrange these six events from earliest to latest according to the chronology stated in the case. Treat the year-end inventory reconciliation as occurring after the year's sales are finalized.

Dragging, or the arrow buttons, to reorder.

The year's finalized sales show that only 14,200 kits were sold.
Finance imposes the 18,000-unit sales target without account-team input.
The newly commissioned cell's 18,000-unit capability becomes available to management.
The export certification is delayed after the sales target has been approved.
The year-end reconciliation shows finished goods above the intended inventory target.
Executives choose 18,000 units as the production target based on the cell's capability.

Saving…

LumenQuay can retain central Role retained by executives while inviting account teams to contribute forecasts. Participation gives executives better information about Information supplied through participation . To discourage budgetary slack, reviewers should challenge proposals that contain Possible slack indicator .

Using actual production of 18,000 kits and actual sales of 14,200, how many ending-inventory units exceed LumenQuay's 1,100-unit target? Opening inventory was 900 units. Enter a positive whole number of excess units; no rounding is necessary.

Answer units

A whole number.

The marks, the correct answers and the explanations appear as soon as the answers are submitted. Unanswered questions earn no marks.

Checking…