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

Here is the DQ as we discussedWeek 4 Due Thur July 24th in the pm hours.docx

Focus of the Final Project: APA Formateight pages in length and include a reference of all resources used. At least three sources should be from scholarly journals, e.g. Journal of Management, Journal of Marketing, or Harvard Business Review. This paper will be a research project that tests a hypothesis chosen by the student that can relate to the place of current employment or previous employment but may not include or involve human subjects directly.Sample general topics could include:Manufacturing Quality/Cost ImprovementService Quality ImprovementSystems DesignAccounts Receivable/Billing/AR AgingMarketing/Advertising IssuesSales of GoodsInvestmentsProduct SafetyWorkplace SafetyLabor PoolsHR matters of broad concernPopulation StudiesOthers approved by course instructorThe hypothesis should be a possible cause and effect relationship regarding a process, underlying assumption, or plan that is important to the business. It should not be too broad. The hypothesis must be approved by the instructor by the end of the third week of class. The research process of planning, data sampling, collection and data evaluation should be described. The type of study should be defined and justified. Collect a small representative data sample. Fifteen is the recommended sample size. The data can be collected from observations, surveys, or historical records. The data results should be summarized and displayed and a brief analysis should be included. Use appropriate descriptive or inferential statistics.