Making a Workbook in Excel for Accounting

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

Looking for this or a Similar Assignment? Click below to Place your Order

Open chat
%d bloggers like this: