Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
Mr. Homer Simpson, President and Chief Executive Officer of Duff's Beer Making Supplies Inc. recently hired you as the new budget analyst for his company. As your first duty, he has asked you to prepare an Excel workbook that can be used to tract sales / revenues, make sales forecasts and track employee commissions.
The workbook that you create should be professional in appearance, be easily understandable to other employees, utilize cell references when ever possible and be completely flexible with the ability to alter any constant in a single cell.
At a minimum, you should have separate worksheet for listing the products / prices / commission rates, an individual worksheet for each individual region and a single summary sheet for Mr. Simpson to review. (You may elect to have more worksheets in order to improve overall appearance, usability and understandability of your workbook.)
The summary worksheet (s) should provide the following information:
There should be a minimum of three charts / graphs that provide "relevant" information. Examples would be comparing current revenues to last year, using a trend line to forecast sales and / or comparison of sales / commissions for each region or salesperson.
You should use the "subtotals" and "name" commands in the worksheet when appropriate.
From the information provided, determine: 1.) The amount of retained earnings at December 31 and 2.) The amount of revenues for the period. Additional data:1.)Expenses for the peri
Chrome-It, Inc., manufactures special chromed parts made to the order and specifications of the customer. It has two production departments, stamping and plating, and two service
Operating Income 1. Operating Income is derived from two sources, Rental Income from businesses operating in the warehouse complex and Interest Income of the project operating
Labour Costs and Overhead costs Labour Costs Labour costs can be indirect or direct labour costs. Direct labour cost refers to wages paid to workers who such are directly
explain advantages of marginal costing
Determine the Joint Cost A company produces three products, Y1, Y2, and Y3 in the similar process. The data below reflects average monthly results as:
Material Cost Control Therefore Materials form an important cost of output units and that should be controlled. Material Control is more than merely recording the accounting
What are investment appraisal methods when opening a new project?
In an application of a hand-held clinical thermometer for the National Health Service it is required to use disposable temperature sensors and digital read out of temperature betwe
Do I use the contribution per unit and the total sales for the department in order to calculate the p/v ratio for a department
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd