Business Finance
Making a Workbook in Excel for Accounting

Question Description

I’m studying for my Business class and don’t understand how to answer this. Can you help me study?


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

Student has agreed that all tutoring, explanations, and answers provided by the tutor will be used to help in the learning process and in accordance with Studypool's honor code & terms of service.

Final Answer

rajdeep77 (1361)
UT Austin

Top quality work from this tutor! I’ll be back!

It’s my second time using SP and the work has been great back to back :) The one and only resource on the Interwebs for the work that needs to be done!

Thanks, good work

Similar Questions
Related Tags