Cost Accounting

profileAhmad_Aljohani12
ACC501CookieTemplateSpr22.xlsx
Home>Business & Finance homework help>Accounting homework help>Cost Accounting

Inputs

Direct Materials Total CVP Analysis
Total Variable Costs Per unit
Sales Price Per unit
Variable costs
Markup
Sale price
Contribution Margin Per unit
Total cost of direct materials, per batch Selling price
Number cookies per batch less: Total variable costs
Cost of direct materials per cookie
Times cookies in sales unit
Total cost of direct materials, per unit
Direct Labor Total
Total cost of direct labor, per batch
Number cookies per batch
Cost of direct labor per cookie
Times cookies in sales unit
Total cost of direct labor, per unit
Variable Manufacturing Overhead Total
Total cost of variable MOH, per batch
Number cookies per batch
Cost of VMOH per cookie
Times cookies in sales unit
Total cost of VMOH, per unit
Variable Operating Expenses Total
Total cost of variable operating expenses, per unit
Fixed Manufacturing Expenses, Per Month Total
Total cost of fixed manufacturing expenses, per month
Less: Depreciation Expense
Total cash paid for fixed manufacturing expenses
Fixed Operating Expenses Total
Total cost of fixed operating expenses, per month
Less: Depreciation Expense
Total cash paid for fixed operating expenses

Operating Budgets

Sales & Cash Collections Budget
Jan Feb Mar QTR APR MAY
Units Sold
Selling price per unit
Total sales
Cash collected, CM
Cash collected, 1M
Cash collected, 2M
Total cash collected
Production Budget
Jan Feb Mar QTR APR MAY
Units Sold
Add: Desired Ending Inventory
Units needed
Less: Beginning Inventory
Units to produce
Direct Materials Cash Budget
Jan Feb Mar QTR APR MAY
Units to produce
Add: Desired Ending Inventory
DM Needed for production
Less: Beginning Inventory
Units of DM Needed
x Cost of DM per unit
Total cost of DM
Paid in CM
Paid in 1M
Paid in 2M
Total cash paid
Direct Labor Payments Budget
Jan Feb Mar QTR
Units to produce
x Direct labor cost per unit
Total cost of direct labor
Manufacturing Overhead Cash Payments Budget
Jan Feb Mar QTR
Units to produce
x Variable MOH rate
Total Variable MOH
Add: FMOH Cash Payments
Total MOH Cash Payments
Add: Non-Cash FMOH
Total MOH
Operating Expense Cash Payments Budget
Jan Feb Mar QTR
Units Sold
x Variable OpExp rate
Total Variable OpExp
Add: FOpEx Cash Payments
Total OpEx Cash Payments
Add: Non-Cash FOpEx
Total OpEx

Financial Budgets

Cost to manufacture per unit
QTR
DM per unit
DL per unit
VMOH per unit
Total variable manufacturing cost
Total FMOH
/ Units produced
FMOH per unit produced
Total CoGS per unit
Your Cookie Co.
Combined Cash Budget
For the months and quarter ended,
Jan Feb Mar QTR
Beginning Cash
Add: Owner contributions
Proceeds from loan
Cash collections
Cash Available
Less: Payments for DM
Payments for DL
Payments for MOH
Payments for OpExp
Capital expenditures
Cash payments
Cash before financing
Add: Cash from (paid to) line of credit
Less: Interest paid
Ending cash
Interest Calculations:
Outstanding Debt
Interest
Your Cookie Co.
Income Statement (Absorption)
For the quarter ended,
QTR
Sales revenue
Less: Cost of Goods Sold
Total CoGS per unit
x Units sold
Total CoGS
Gross Profit
Less: Operating expenses
Variable OpEx per unit
x Units sold
Total Variable OpEx
Add: Fixed OpEx
Total OpEx
Operating income (loss)
Less: Interest expense
Net Income (Loss)
Your Cookie Co.
Balance Sheet
For the quarter ended,
QTR
Assets
Cash
Accounts Receivable
Inventory, Raw Materials
Inventory, Finished Goods
Equipment
Less: Accumulated Depreciation
Total Assets
Liabilities
Accounts Payable
Line of credit
Bank loan
Total Liabilities
Equity
Common Stock
Retained earnings
Total Equity
Total Liabilities and Equity