Create master budget, Apple Inc. manufacturers I-phones.

Create master budget

Assignment Help Business Management

Reference no: EM133149072

Background

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:

1. 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.

2. Each budget should be prepared on individual Excel spreadsheets, on separate tabs.

3. 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.

4. Briefly discuss your assumptions and any challenges you encountered while preparing the budget.

Reference no: EM133149072

Questions Cloud

Important for business analysis : Do you think that the use of Charts and Graphics is important for a Business Analysis?

Transactional and transformational leadership : Distinguish between transactional and transformational leadership. Be sure to give specific examples of each style.

Discuss the components and use of financial analysis : Describe the elements and purpose of each financial statement. Discuss the components and use of financial analysis.

Different types of employee benefit programs : Analyze the different types of employee benefit programs that a company might put into place.

Create master budget : Apple Inc. manufacturers I-phones. You have been hired as a cost accountant and your assignment to create a master budget using EXCEL..

Analyze the impact of those trends on the firm : Identify the major trends in the general environment of that firm. Analyze the impact of those trends on the firm.

Renewable energy corporation : Use Renewable Energy Corporation case (from Harvard) to research the company's business model, internal resources, external environment, competitive landscape

Workplace violence happens : In addition to the human costs of such violence, what are some of the economic loss from workplace violence?

Marketing the brand-developing marketing plan : Determine two methods to be used for consumer research in developing the marketing plan.

User Account

All Pages