The Cable Service Division reported the following activity for the month of March:

$$ Basic Enhanced Premium

Sales : $50,000500,000300,000$

Price per unit: $$32$ $$60$ $$90$

Unit costs:

Directly traced $$6$ $$18$ $$36$

Driver traced $$4$ $$8$ $$12$

Allocated $$20$ $$26$ $$30$

$$The unit costs are divided as follows: $70$percent production and $30$percent marketing and customer service. Direct labor cost is the only driver used for tracing.

Inventories:

$$Materials$,$March $1,$$$23,000$

$$Materials$,$March $31,40,000$

$$Work in process, March $1,130,000$

$$Work in process, March $31,45,000$

$$Finished goods, March $1,480,000$

$$Finished goods, March $31,375,000$

Costs:

$$Direct labor, $$117,000$

$$Plant and equipment depreciation, $50,000$

$$Materials handling, $85,000$

$$Inspections$,60,000$

$$Scheduling$,30,000$

$$Power$,30,000$

$$Plant supervision, $12,000$

$$Manufacturing engineering, $21,000$

$$Sales commissions, $120,000$

$$Salary$,$sales supervisor, $10,000$

$$Supplies$,17,000$

$$Warranty work, $40,000$

During March, the Phone Division purchased materials totaling $$312,000.$There are no significant inventories of supplies $($beginning or ending$).$Supplies are accounted for separately from materials. CTB$$s Phone Division had sales totaling $$1,170,000$for March

For one of our conventional phone plants, I regressed total monthly overhead cost on monthly direct labor cost using the following $15$months of data:

Overhead Direct Labor Cost

$$360,000$ $$110,000$

$300,000100,000$

$350,00090,000$

$400,000100,000$

$320,00090,000$

$380,000100,000$

$300,00090,000$

$280,00090,000$

$340,00095,000$

$410,000115,000$

$375,000100,000$

$360,00085,000$

$340,00085,000$

$330,00090,000$

$300,00080,000$

A$.$Can you help me prepare income statements for the Cable Service Division and for the Phone Division for March. For the income statement associated with the Phone Division, including a supporting cost of goods manufactured statement?

Please and thank you!