ACC 302 Final Project

final_topic_template_1.xls

Home >Business & Finance homework help >Accounting homework help >ACC 302 Final Project

Week 5


Break Even Analysis
Recipe: 1 dozen pretzels
Ingredient	Units	Unit cost	Usage	Cost
Flour	cup	$0.15		$0.00
Sugar	cup	$0.15		$0.00
Yeast	cup	$0.50		$0.00
Oil	half cup	$1.00		$0.00
Egg	cup	$0.10		$0.00
Salt	half cup	$0.75		$0.00
Other	cup	$2.00		$0.00
	Variable direct material costs per dozen			$0.00
	Variable overhead costs per dozen
	Variable operating costs per dozen
		Total variable costs per dozen		$0.00
	Mark-up
	Sales price per dozen			$0.00
	Contribution margin			$0.00
Monthly fixed costs:
	Manufacturing overhead
	Operating expenses
				$0
	Months			3
		1st quarter fixed costs		$0
	Break even units
	Break even sales

Week 6a


						Quarterly sales projections:
						Name	January	February	March	April
						A-F	3750	3750	3750	3750
		Sales and Cash Collections Budget				G-L	2750	3250	4000	5000
		Quarter Ending March 31, 2011				M-S	2000	3500	4500	5000
						T-Z	1750	3750	3500	6000
		January	February	March	Total
Sales:
	Unit sales in dozens
	Selling price per dozen
	Total sales	$0	$0	$0	$0
	Total cash sales (40%)
	Total credit sales (60%)
Cash collections:
	Current month cash sales
	Collection of credit sales
	Total cash collections	$0	$0	$0	$0
	Quarter end receivables
		Direct Material Purchases
		and Cash Disbursements Budget
		Quarter Ending March 31, 2011
		January	February	March	Total	April
Flour:
	Unit production in dozens
	Raw material per dozen
	Production needs					0
	Add: Planned ending inventory
	Total needs
	Less: Beginning inventory
	Raw materials to be purchased
	Cost per unit used
	Total cost of raw materials	$0	$0	$0	$0
Sugar:
	Unit production in dozens
	Raw material per dozen
	Production needs					0
	Add: Planned ending inventory
	Total needs
	Less: Beginning inventory
	Raw materials to be purchased
	Cost per unit used
	Total cost of raw materials	$0	$0	$0	$0
Dry yeast:
	Unit production in dozens
	Raw material per dozen
	Production needs					0
	Add: Planned ending inventory
	Total needs
	Less: Beginning inventory
	Raw materials to be purchased
	Cost per unit used
	Total cost of raw materials	$0	$0	$0	$0
Oil:
	Unit production in dozens
	Raw material per dozen
	Production needs					0
	Add: Planned ending inventory
	Total needs
	Less: Beginning inventory
	Raw materials to be purchased
	Cost per unit used
	Total cost of raw materials	$0	$0	$0	$0
Eggs:
	Unit production in dozens
	Raw material per dozen
	Production needs					0
	Add: Planned ending inventory
	Total needs
	Less: Beginning inventory
	Raw materials to be purchased
	Cost per unit used
	Total cost of raw materials	$0	$0	$0	$0
Salt:
	Unit production in dozens
	Raw material per dozen
	Production needs					0
	Add: Planned ending inventory
	Total needs
	Less: Beginning inventory
	Raw materials to be purchased
	Cost per unit used
	Total cost of raw materials	$0	$0	$0	$0
Other ingrediants:
	Unit production in dozens
	Raw material per dozen
	Production needs					0
	Add: Planned ending inventory
	Total needs
	Less: Beginning inventory
	Raw materials to be purchased
	Cost per unit used
	Total cost of raw materials	$0	$0	$0	$0
Total raw material purchases
Less quarter end inventory			Units	Unit cost	Total
	Flour
	Sugar
	Dry yeast
	Oil
	Eggs
	Salt
	Other
	Raw materials inventory at March 31				$0
	Cost of goods sold
Budgeted cash disbursements:
	25% of current month's purchases
	75% of prior month's purchases
		$0	$0	$0	$0
	Quarter end accounts payable

Week 6b


		Manufacturing Overhead Budget
		Quarter Ending March 31, 2011
		January	February	March	Total
	Unit production in dozens
	Variable manufacturing overhead per dozen
	Budgeted manufacturing overhead	$0	$0	$0	$0
	Budgeted fixed overhead
	Total budget	$0	$0	$0	$0
	Less: non-cash depreciation
	Cash disbursements for manufacturing overhead	$0	$0	$0	$0
		Operating Expense Budget
		Quarter Ending March 31, 2011
		January	February	March	Total
	Unit production in dozens
	Variable operating expenses per dozen
	Budgeted variable expense	$0	$0	$0	$0
	Budgeted fixed operating expenses
	Total budget	$0	$0	$0	$0
	Less: non-cash depreciation
	Cash disbursements for operating expenses	$0	$0	$0	$0
		Cash Budget
		Quarter Ending March 31, 2011
		January	February	March	Total
Receipts:
	Cash, beginning balance
	Capital contributions
	Collections from customers
	Total cash available	$0	$0	$0	$0
Disbursements:
	Direct materials
	Manufacturing overhead
	Operating expenses
	Equipment purchases
	Total disbursements	$0	$0	$0	$0
Excess (deficiency) of cash
	Bank loan
	Draws on line of credit
	Repayments
	Interest payments
	Cash, ending balance	$0	$0	$0	$0
Interest expense (1% per month on outstanding balance)
Accrued interest at quarter end
	Proforma Variable Income Statement
	Quarter Ending March 31, 2011
Sales
Variable costs:
	Direct materials
	Manufacturing overhead
	Operating expenses
	Total variable costs
	Contribution margin
Fixed costs:
	Manufacturing overhead
	Operating expenses
	Interest expense
	Total fixed costs
	Operating income (loss)
	Income taxes
	Net income (loss)
	Proforma Absorption Income Statement
	Quarter Ending March 31, 2011
Sales
Cost of goods sold:
	Direct materials
	Manufacturing overhead
	Total cost of goods sold
	Gross margin
	Operating expenses
	Interest expense
	Operating income (loss)
	Income taxes
	Net income (loss)
	Proforma Balance Sheet
	March 31, 2011
Current assets:
	Cash
	Accounts receivable
	Raw materials inventory
	Total current assets
	Fixed assets
	Less accumulated depreciation
	Net fixed assets
	Total assets
Current liabilities:
	Accounts payable
	Accrued interest payable
	Bank loan and line of credit
	Total current liabilities
Owner's equity:
	Capital contribution
	Retained earnings
	Total equity
	Total liabilities and equity