produce_a_workbook_in_excel.docx
Let’s use excel for creating software for a company to use frequently for break-even analysis, budgeting and variance analysis. The software (excel workbook) should be attractive and user friendly: The name of the company is:
Natural Fragrance, Inc., began operations on January 1, 2012. The company produces a hand and body lotion in an eight-ounce bottle called Eternal Beauty. The lotion is sold wholesale in 12-bottle cases for $80 per case. There is a selling commission of $16 per case. The January direct materials, direct labor, and factory overhead costs are as follows:
Make a workbook in excel and apply the worksheets within it.
Spreadsheet One: Break-Even Analysis
Determine a fixed and variable portion of a utility cost using the high-low method.
Determine a contribution margin
Determine a fix cost
Determine a break-even number
Spreadsheet Two: Budgets
Include a production budget
Include a direct materials purchase budget
Include a direct labor budget
Include a factory overhead budget
Include a budgeted income statement
Spreadsheet Three: Variance Analysis
Determine a direct material price and quantity variances
Determine a direct labor rate and time variances
Determine a factory overhead controllable variance
Determine a factory overhead volume variance
(see attachment) Please use excel 2003 and higher only
