I need help filling in the yellow cells shown in photo.

Background: I SEE THE LIGHT $($ISTL$)$ is a subchapter S corporation that manufactures children's lamps$/$nightlights for use in bedrooms. These lamps are sold nationwide through a group of independent sales representatives who have an exclusive sales region. The business is in its tenth year and has asked you to assist in planning for next year's operations.

The lamps are ceramic figurines of animals, boats, boys and girls playing and singing, all in delightful colors. The owner of the business, Big Al$,$ creates a drawing for the figurine and faxes it to a plant in China where a mold is created and a sample produced and hand painted. If the mold meets the expectations of Big Al an order of $500$ lamp parts is placed. Each lamp kit consists of the parts required to complete one lamp; a figurine, a lamp shade and the required electrical components. There are presently $10$ different figurines that come in six different colors; $60$ models.

There are presently $10$ workers in the plant. They are responsible for receiving the raw material, manufacturing the product, packing and shipping. In addition to Big Al there are two office workers who are responsible for all administrative duties.

Big Al had his accountant prepare the Projected Income Statement and Balance Sheet presented on page two. Big Al heard about your skills in managerial accounting and would like your assistance in the following areas:

Part $1$

Process Costing

Part $2$ Job Order Costing

Sales

Cost of Goods Sold

I See The Light Projected Income Statement

For the Period Ending December $31,20$x$1$

Sales $25000$ lamps @$$45\mathrm{.}00$ $$1,125,000\mathrm{.}00$

Cost of goods sold @$$30\mathrm{.}00750,000\mathrm{.}00$

Gross Profit $$375,000\mathrm{.}00$

Selling expenses:

Fixed $$23,000\mathrm{.}00$

Variable $($commision per unit$)$ @ $$3\mathrm{.}0075,000\mathrm{.}00$ $$98,000\mathrm{.}00$

Administrative Expenses:

Fixed $$42,000\mathrm{.}00$

Variable @ $$2\mathrm{.}00$ $$50,000\mathrm{.}0092,000\mathrm{.}00$

Total selling and administrative expenses: $190,000\mathrm{.}00$

Net profit $ $185,000\mathrm{.}00$

Project balance sheet as of Dec $31$

Current Assets

Cash $$34,710\mathrm{.}00$

Accounts Receivable $67,500\mathrm{.}00$

Inventory

Raw Material

Lamp Kits $500$ @$$16\mathrm{.}008,000\mathrm{.}00$

Work in Process $0$

Finished Goods $3000$ @ $$30\mathrm{.}0090,000\mathrm{.}00$

Total Current Assets $$200,210\mathrm{.}00$

Fixed Assets

Equipment $$20,000\mathrm{.}00$

Accumulated Depreciation $6800\mathrm{.}00$

Total Fixed Assets $13,200\mathrm{.}00$

Total Assets $$213,410\mathrm{.}00$

Current Liabilities

Accounts payable $$54,000\mathrm{.}00$

Total Liabilities $$54,000\mathrm{.}00$

Stockholders equity

Common stock $$12,000\mathrm{.}00$

Retained earnings $147,410\mathrm{.}00$

Total stockholders equity $159,410\mathrm{.}00$

Total Liabilities and stockholders equity $$213,410\mathrm{.}00$

$$

Process Costing $-$ First$-$In First$-$Out

General Information

The I See The Light Company has a related company that produces the figurines. They use process costing

in the molding department. The factory overhead is applied at a rate of $50\%$ of direct labor dollars.

The material is added at the beginning of the process. The labor and overhead costs are assumed to be added uniformly throughout.

Month of January

Selected information for January is presented below. Note that the applied overhead rate was $50\%$ of direct labor costs in the molding department.

Molding Department

Goods in$-$process as of January $1$ were $3,400$ figurines at a cost of $$62,560\mathrm{.}00.$ Of this amount, $$54,400\mathrm{.}00$ was from raw materials added, $$5,440\mathrm{.}00$ for labor and $$2,720\mathrm{.}00$ for overhead. These $3,400$ figurines were assumed to be $80\mathrm{.}00\%$ complete as to labor and overhead.

During January, $22,500$ units were started, $$364,725\mathrm{.}00$ of materials and $$42,760\mathrm{.}00$ of labor costs were incurred.

The $6,000$ figurines that were in$-$process at the end of January were assumed to be $70\mathrm{.}00\%$ complete to labor and overhead.

All figurines in January passed inspection.