BUDGET PROBLEM

Jonick Sports, Inc. manufactures a unique type of protective helmet.

The following is the company's budget information for April:

A$.$ Estimated sales of helmets for April:

$\frac{\text{Q}\text{u}\text{a}\text{n}\text{t}\text{i}\text{t}\text{y}}{6,900}\frac{\text{U}\text{n}\text{i}\text{t}\text{p}\text{r}\text{i}\text{c}\text{e}}{\text{\$}325}$

B$.$ Estimated inventories at April $1$:

Direct materials:

Plastic

Pounds

Foam lining

$110$

$70$

C$.$ Desired$/$anticipated inventories at April $30$:

Direct materials:

Plastic

Pounds

$150$

Work in process:

Foam lining

$50$

Instructions

Enter formulas and$/$or functions in the yellow cells for questions #$1$ through $7$ that result in various budget$-$related amounts for April.

a$.$ Use variables$/$cell references rather than typing numbers into the formulas.

b$.$ Only reference cells where data is given or where you entered a previous answer. Do not use "helper cells".

c$.$ Use the SUM and SUMPRODUCT functions at least once each.

All items except #$2$ are asking for dollar amounts.

Estimated sales

Number of units to produce

Total direct materials to be purchased

Total direct labor cost

Total factory overhead

Total manufacturing costs

Cost of goods manufactured

D$.$ Direct materials used to produce each helmet:

$\backslash$table$[[,,,,,],[$Plastic$,$Pounds,,,,$],[$Foam lining,$2\mathrm{.}5,,,,],[,0\mathrm{.}5,,,,]]$

E$.$ Anticipated cost per pound of purchases and inventory amounts of direct materials:

$\backslash$table$[[,$Costperlb.,,$],[$Plastic$,$$$35,,],[$Foam lining,$$17,,],[$nticipated direct labor requirements to produce each he$],[,,$Hours,Hourlv cost$],[$Molding Department,$2\mathrm{.}0,$$$30$