For YOURlecturer only

Scalia Systems manufactures rugged handheld computers for use in adverse working environments. Scalia tries to maintain inventory at 40% of the following month's expected unit sales.

Scalia began the year with 8,000 units in stock, based on the following unit sales projections prepared by the sales manager:

January 20,000

February 25,000

March 18,000

April 22,000

Prepare a schedule of planned unit production for January through March.

Planning for production B-21.03

x SPREADSHEET

TOOL:

Column/Row headings

Spreadsheet f x

A B C D E F

1

2 Production Budget

3

4 January

5 Estimated units sold

6

7

8

9

1 0

1 1

1 2

Sales Production Materials Labor Factory Overhead Finished Goods SG&A Cash Income

Planning for production B-21.03