Ch$22-$ Excel Assignment

eBook

Show Me How

Office $365$

Price per pound

$$0\mathrm{.}50$

$$0\mathrm{.}60$

$$0\mathrm{.}85$

This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below

x$$

Open spreadsheet nearest dollar.

Tobin's Frozen Pizza Inc

Direct Materials Purchases Budget

For the Month Ending November $30$

Units required for production:

$12"$ pizza

$16"$ pizza

Desired inventory, November $30$

Total units available

Estimated inventory, November $1$

Total units to be purchased

Unit price

Total direct materials to be purchased

$\backslash$table$[[37,950,,19,600,$x$,48,300,,],[39,200,,19,600,,58,800,,],[2,000,,1,200,,2,800,,],[,$x$,,$x$,,$x$,],[,$X$,,x,,x,],[,$X$,,x,,x,],[0\mathrm{.}50,,0\mathrm{.}60,,0\mathrm{.}85,,],[,x,,$x$,,x,$x$]]$

Previous

Check My Work $3$ more Check My Work uses remaining

Assignment Score: $42\mathrm{.}37\%$