professional application 3 budget project continued northern navigation company

The first thing you need to do before starting is not fix the following problems in the excel,

Memo – several typos, duplicate words, or not complete sentences.

Production Budget – cells F7 and F9 are not right, sometimes the annual amount is the sum of the four quarters and sometimes it is not and is just a specific point in time

Direct Materials – cells F8 and F10 are not right,

Cash Budget – cell B8 is not right, row 11 is not right, cell B26 is not right, row 29 is not right, row 50 and row 51 are not right, this is a cash budget so we want only the cash expenditures, we don’t want to include the non-cash items, maybe read the hints in column H, row 58 is not right, row 71, row 72 and row 73 are not completed, the spending for capital equipment purchases and dividends would make your cash balance go negative, we don’t want to borrow any cash,

Now you can start with the PA #3 instruction to finish the excel.