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:
OUR PROCESS
Order
Payment
Writing
Delivery
Why Choose Us: Cost-efficiency, Plagiarism free, Money Back Guarantee, On-time Delivery, Total Сonfidentiality, 24/7 Support, 100% originality
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