MAKING A WORKBOOK IN EXCEL

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 

WHY SHOULD YOU HIRE EXPERT ACADEMIC WRITERS?

Answering this question is not essay as it seems. It will require you to research or burn your brain power, write your findings down, edit, proofread severally, and submit unsure of the grade you will get. Classaider.com assignment writers are offering to take care of that. Order your assignment now, relax, submit, and enjoy excellent grades. We guarantee you 100% original answers, timely delivery, and some free products.

>>ORDER NOW<<

>>SEE TOP WRITERS<<