determine the environmental variable most likely to affect the short-run production over the next 12 months. Determine what managers can do to prepare for the possible change in short-run production.Pick a real or fictitious business. Create a scenario around this business in which a manager would decide to either stop operations in the short-run or going out of business in the long-run. Provide a rationale with your response.

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