Apple Inc. manufacturers I-phones. You have been hired as a cost accountant and your
assignment to create a master budget using EXCEL.. You have been working with various
departments to gather financial data to assemble a master budget. One reason you have
chosen this format is that upper management will probably make some last-minute changes
to sales and possible changes to some other cost forecasts. So, to simplify this problem you
MUST link all the budgets together. For example, if you change the sales forecast, then all
the remaining numbers in all other budgets would change without having to change numbers
manually in each budget.
One quarter of the budget has been prepared for you but you need to input the other three
quarters in order to prepare the income statement.
Here are the steps:
- You must setup all eight budgets using Excel. Starting with the sales budget, manually
calculate the sales budget forecast for all four quarters and calculate the total column
- Each budget should be prepared on individual Excel spreadsheets, on separate tabs.
- Each budget should professionally represent all the budget information; must be easy
to understand so it can be presented to the CEO and the owners of the business.
- Briefly discuss your assumptions and any challenges you encountered while preparing
ainst one of the biggest currencies, the pound was “18% lower than the dollar” (Monaghan 2016). As you can see below, the graph shows how the value of pound dropped when the decision of the referendum was released. Since then, the value of the pound has stayed low as people are still unsure of what is going to happen when the article 50 is triggered and the UK has left the EU completely. These effects below are only the start of the consequences to the UK leaving. People stopped investing their money in the pound worried about what was going to happen. As there was a drastic drop in the investments in the pound; at the same time there are businesses at this point in time deciding to move their businesses to another country. A big example is Vodafone as they are looking to move their headquarters. The reason they wanted to move is because they liked the free movement of people within EU as it was easy to get capital and goods around and it benefited the company. (Palmer, 2016) (Trading, 2016) The value of the pound is depreciating as you can see from the chart above, the prices of houses within the UK is falling. This isn’t due to the high supply; however, it is due to the outcome of the referendum as people are not buying houses as no one knows what other drawbacks are going to be because of the UK leaving. Citizens of the UK are not buying houses at this current time because they are considering whether it would be the best decision to make an investment in a house and stay in the UK or move abroad depending on what other consequences we are going to have to face because of the vote to exit the EU. As the decision was made by the UK to leave, there has been a “0.4%” increase in the inflation rates as you can see in the graphs below (Statistics, 2016a). As the pound fell, the demand for goods and services increased because when the pound is converted into different currencies, the value of the pound worked out cheaper for other countries to purchase. Therefore, this was taken as an advantage as they would be able to buy more for the price they pay now in comparison to before. As mentioned, the demand has increased so the prices of goods and services have also increased too which has a similar effect on tourism. This has had a positive effect on our economy as the employment rate figures have gone down as the more tourism we get the more jobs there are to keep up with demand. (Ferreira, 2016)>GET ANSWER