MAKE THAT LAST MINUTE ADJUSTMENT Continue your work anywhere with the Office Mobile ApP

Get started

C$9$

A

$1.$

$2$

INPUT SECTION

SALES

RECEIVABLES

$15$ Receivables collection Schedule

$16$

$17$

$18$

$20$

$21$

$22$

$23$

INVENTORY COSTS

Direct Labor

customization

PROJECT INFORMATION

PROJECT INFORMATION

Sales Budget

$8$:$26$ AM

A

$\backslash$table$[[$Raw Materials,,,$],[,3,$pounds per finished goods unit$],[$$$,85\mathrm{.}00,$per pound$],[$Variable Overhead,$$,10\mathrm{.}50,$per Direct Labor Hour$],[$Fixed Overhead,,,$],[\backslash$table$[[$Depreciation$],[$Other Fixed Overhead$]],$$$,196,240,$per quarter$],[$er Fixed Overhead,$$,950,000,$per quarter$]]$

Fixed Overhead Application Rate

CALCULATE FROM PRODUCTION BUDGET

INVENTORY ACCOUNTS

Finished Goods Inventory

$\backslash$table$[[4$th Quarter,$1$st Quarter,$2$nd Quarter,$3$rd Quarter,$4$th Quarter$],[2024,2025,2025,2025,2025],[,15,000,19,000,20,000,16,000]]$

Raw Materials Inventory

Beginning units on $\frac{1}{1}\frac{?}{2025}$

Planned Ending units on $\frac{12}{31}\frac{?}{2025}$

$41,368$ pounds

$26,000$ pounds

Policy

$25\mathrm{.}00\%$ of next quarters' needs for production is in ending Raw Materials InventoryCAPITAL EXPENDITURESFLEXIBLE BUDGET

Actual Units Produced

USE VALUE FROM PRODUCTION BUDGET

Flexible Budget $-$ Analyze at Additional Production Levels

$1$

$\backslash$table$[[,,\backslash$table$[[$O$],[$O$]],\backslash$table$[[$o units$],[$units$]]],[\{$

$\backslash$table$[[$Zen Innovation$],[$Balance Sheet$]]\}],[],[,,$Balance Sheet,$],[,,12/31/2024,],[,$Cash ASSETS,$\backslash$table$[[6,150,000$