Making a Workbook in Excel for Accounting

/in /by

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

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.