Computer Accessories Inc. assembles a computer networking device from kits of imported components. You have been asked to develop a quarterly and annual operating budget and pro forma income statements for next year. You have obtained the following information:

Beginning$-$of$-$year balancesCash$$75,000$Accounts receivable $($previous quarter$$s sales$)$$$245,000$Raw materials$950$kitsFinished goods$1,500$kitsAccounts payable $($materials$)$$$125,000$Borrowed funds$$30,000$Desired end$-$of$-$year inventory balancesRaw materials$1,000$kitsFinished goods$1,600$kitsDesired end$-$of$-$quarter balancesCash$$30,000$Raw materials as a portion of the following quarter$$s production$0\mathrm{.}20$Finished goods as a portion of the following quarter$$s sales$0\mathrm{.}30$Manufacturing costsStandard cost per unitUnitsUnit priceTotalDirect labor hours at rate$0\mathrm{.}50$ hour$$30\mathrm{.}00$$$15\mathrm{.}00$Raw materials$1$ kit$$75\mathrm{.}0075\mathrm{.}00$Variable overhead$/$labor hour$0\mathrm{.}50$ hour$$5\mathrm{.}002\mathrm{.}50$Total standard variable cost$$92\mathrm{.}50$Fixed cost per quarterCash$$110,000$Depreciation$15,000$Total$$125,000$Selling and administrative costs$$8\mathrm{.}00$Variable cost per unitFixed costs per quarterCash$$150,000$Depreciation$7,500$Total$$157,500$Interest rate per quarter$0\mathrm{.}015$Portion of sales collectedQuarter of sale$0\mathrm{.}70$Subsequent quarter$0\mathrm{.}29$Bad debts$0\mathrm{.}01$Portion of purchases paidQuarter of purchase$0\mathrm{.}60$Subsequent quarter$0\mathrm{.}40$Unit selling price$$225$Sales forecastQuarterFirstSecondThirdFourthUnit sales$4,4004,6004,5004,800$

Additional information

$$ All cash payments except purchases are made quarterly as incurred.

$$ All borrowings occur at the start of a quarter.

$$ All repayments on borrowings occur at the end of a quarter.

$$ At the time the principal is repaid, interest is paid on the portion of principal that is repaid.

$$ Borrowings and repayments may be made in any amount

Required

Note: Do not use negative signs with any of your answers in the requirements that follow.

Part A

Part B

Part C

Part D

Part E

Part F

Part G

d$.$ A manufacturing cost budget for each quarter and the year.

Electric Monkey Computer AccessoriesManufacturing Cost BudgetFor the Year Ending December $31$FirstSecondThirdFourthTotalProduction requirements:Answer $66$

Answer $67$

Answer $68$

Answer $69$

Answer $70$

Manufacturing resource requirements:Direct materialsAnswer $71$

Answer $72$

Answer $73$

Answer $74$

Answer $75$

Direct labor hoursAnswer $76$

Answer $77$

Answer $78$

Answer $79$

Answer $80$

Variable manufacturing costs:Direct materialsAnswer $81$

Answer $82$

Answer $83$

Answer $84$

Answer $85$

Direct laborAnswer $86$

Answer $87$

Answer $88$

Answer $89$

Answer $90$

Manufacturing overheadAnswer $91$

Answer $92$

Answer $93$

Answer $94$

Answer $95$

Total variable costsAnswer $96$

Answer $97$

Answer $98$

Answer $99$

Answer $100$

Fixed manufacturing costsAnswer $101$

Answer $102$

Answer $103$

Answer $104$

Answer $105$

Total manufacturing costsAnswer $106$

Answer $107$

Answer $108$

Answer $109$

Answer $110$