Lets use excel for creating software for a company to use

Assignment Help Finance Basics

Reference no: EM13390848

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

Reference no: EM13390848

Questions Cloud

Write down the pros and cons of strategic piggybacking in : a what are the pros and cons of strategic piggybacking? in what way is it unfair competition for not-for-profits to

Explain three major cross-cultural differences which would : businesses large and small now compete in a truly global economy. to be successful in another country it is essential

Write down some of the constraints on the strategic : 1. what are some of the constraints on the strategic management of non-profits and how can they be addressed?2. are

Using your own present or previous place of work as an : using your own present or previous place of work as an example propose a method for mitigating the problem of separate

Lets use excel for creating software for a company to use : lets use excel for creating software for a company to use frequently for break-even analysis budgeting and variance

On the graph demonstrate the area which represents net loss : assume the graph below represents the market demand for a patented prescription drug together with the long run

Would you consider the approach incompatible with long run : jet blue corporation continuously offers fare discounts to attract customers awareness about the company increase

Submit a 2 to 4 page apa-style paper which summarizes each : submit a 2 to 4 page apa-style paper that summarizes each phase of the project lifecycle and analyzes how each phase

Find out the annual cost of ordering and carrying the : a grocery store carries a particular brand of coffee that has the following characteristicssales 8 cases per

User Account

All Pages