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




Why Choose Us

  • 100% non-plagiarized Papers
  • 24/7 /365 Service Available
  • Affordable Prices
  • Any Paper, Urgency, and Subject
  • Will complete your papers in 6 hours
  • On-time Delivery
  • Money-back and Privacy guarantees
  • Unlimited Amendments upon request
  • Satisfaction guarantee

How it Works

  • Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
  • Fill in your paper’s requirements in the "PAPER DETAILS" section.
  • Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
  • Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
  • From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.