Tab A. Sales
Section 1: Projected Sales (to Income Statement)
Budget Sales, in Units
Sales Price
Budgeted Sales, in $
Jan
Feb
Mar
Apr
May
Qtr Total
Section 2: Expected Cash Collection (to Cash Budget)
Jan
Feb
Mar
Apr
Qtr Total
January Sales, in $
February Sales, in $
March Sales, in $
Total Cash Collection, in $
Bad Debt
Expense
(to Tab G)
Check monthly
sales to make
sure you didn't
forget money
Tab B. Production
Section 1: Production Budget (Have to complete this BEFORE the Direct Material Schedule)
Budgeted Sales, In Units (from Sales)
+Desired Ending Inventory, Units
Total Productions Needs, Units
-Less Beginning Inventory, Units
Required Production, Units
Section 2: Cost to make one unit (RM+DL+OH)
Once you have completed tab c, d, and e,
calculate the cost to MAKE ONE unit. Use
this to calculate Section 3. The #will be
the same each month
Section 3: Inventory-Finished (to COGS tabs)
Jan
Feb
Mar
Apr
May
Qtr Total
Jan
Feb
Mar
Apr
Qtr Total
Inventory-Finished, Beginning Balance, in $
Inventory-Finished, Ending Balance, in $
Name:
Group: