Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I complete the first part of the question, now it is the second part: Below is the question. The bold letters is the second part

image text in transcribedI complete the first part of the question, now it is the second part:

Below is the question. The bold letters is the second part that I need help.

Using the following information, create a line item budget showing the areas of Sales and Marketing, Research and Development, and Administrative for Globex Corp. Project your budget out for 4 quarters. Budgets should be broken down by each area (aka department) and reflect the total for each department. It is suggested that you use a spreadsheet to complete this assignment.

The fiscal year for Globex Corp. runs from January 1st through December 31st.

Salaries and wages for the marketing and sales department are a fixed cost of $300,000 for the year.Commissions are estimated to be at 10% of sales for Q1, 15% for Q2, 25% for Q3, and 20% for Q4 based on past data and incentive programs.Payroll taxes are figured at 8.4% of pay.There are no promotions anticipated for this department.

The company anticipates that sales each quarter will be $1.5 million, $2.3 million, $2.9 million, and $500,000, respectively. (Q1-Q4)

Office expenses for both the marketing and sales department and research and development are fixed at $40,000 per year.

The marketing and sales department has an overall advertising budget of $500,000 per year.Advertising expenses follow the same percentage breakdown as commission paid for each quarter.

The marketing and sales department has an overall travel budget of $100,000 annually.Managers are allowed to determine how that budget will be distributed over the course of the year.

A category of other expenses is included in each departments budget, for an allowance of $5,000 quarterly.

The Research and Development department is allocated 10% of quarterly sales from the previous quarter for its new/continuous projects.For example, sales of last fiscal years 4th quarter were $650,000.For this fiscal year 1st quarter, the total project budget for R&Dis $65,000.

The R & D department employs 4 people 3 scientists and one administrative assistant.Salary is as follows:

Administrative assistant:$35,000 annually

Scientist #1:$75,000 annually

Scientist #2:$43.00 per hour, works 25 hours per week

Scientist #3:$80,000 annually

Payroll taxes are figured at 8.4% of wages

The R&D department has capitalized equipment which is depreciated at a rate of $10,000 per quarter.

The R&D department has contracted waste removal services at a monthly price of $6,000.

The R&D department provides each scientist with a professional development fund that can be used throughout the year.Each scientist is allowed to be reimbursed $3000 per year for these expenses

The Administrative department has several fixed expenses.Fixed expenses consist of quarterly insurance payments of $5,000, property taxes of $30,000 that are paid in the 1st and 3rd quarters, an offsite storage rental for $50 per month, and a supplies budget of $6,000 per month.

Utilities are averaged at a rate of $0.35 of each dollar of revenue generated per quarter

The Administrative department uses contracted services that total $3,500 monthly

Salaries for the Administrative department total $425,000 quarterly.Payroll taxes are calculated at 8.4% of salaries.

Health insurance and other benefits for all employees is calculated at a rate of 43.5% of total salaries.

After completing your budget for each department, answer the following questions:

What are the total expenses for each of the 3 departments?

R&D wants to make the part time scientist, scientist #2, a full time position with a salary equivalent to the other two scientists in the department.Based on budgetary constraints, do you think that this request should be approved?

Marketing and sales wants to increase the advertising budget by $250,000 annually.What will the impact on that departments overall budget be if this increase is granted?

The CFO of Globex Corp. has stated that the company needs to decrease total expenses on the administrative side of the house by 5%. After looking at the budget for R&D, M&S, and Administrative, where would you suggest making cuts to save an overall 5% across the 3 departments?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Politics Of Internal Auditing

Authors: Dr. Larry Rittenberg, Patty Miller

1st Edition

0894139053, 978-0894139055

More Books

Students also viewed these Accounting questions

Question

Define nonverbal communication.

Answered: 1 week ago

Question

=+1.3(b), show that a trifling set is nowhere dense [A15].

Answered: 1 week ago

Question

4. What are the current trends in computer software platforms?

Answered: 1 week ago