homework

Hands on Assignment #2

On your graded HOA#1 report, revise your answers (if necessary) before working on your HOA #2 report. Make sure that everything is correct and true based on your initial assumption of your product. Now you have evaluated your client’s cost estimate (use them as your standards), your next step is to produce a budget forecast for the next quarter (beginning April-1 and ending June 30). Project Description:

Use the example of C&C sports (from the text book as reference) and prepare the following for your product line on an excel file. Make sure your assumptions are realistic. Show the individual tables on a single sheet and link the results (when necessary) from different sheets using excel command when needed.

(Reference this link https://www.youtube.com/watch?v=UM_dmXRZRMU to learn more)

1. Sales budget [4 pt]. Here assume that you know your market demand and make a realistic guess.

2. Production budget [4 pt] 3. Direct Material Budget [4 pt] 4. Direct Labor Budget [4 pt] 5. Overhead budget [4 pt] 6. Selling & Admin Expense budget [4 pt] 7. Cost of Goods sold budget [4 pt]

Deliverable:

(1) One single excel file with 7 sheets on it with 7 tables for different forecast shown above. (2) Report: Write a short report (one page word file) on your assumptions that your budget

is based on. Rationalize your assumptions by providing references from your research if necessary. [5 points].