Question: Create a manufacturing company. Using EXCEL, create the sales budget, production budgets), and the income statement. State any assumptions used to create budgets. Explain the

  1. Create a manufacturing company. Using EXCEL, create the sales budget, production budgets), and the income statement. State any assumptions used to create budgets. Explain the steps necessary to build a master budget (Calculations and formulas are required to receive full credit.)
  2. Analyze the metrics below for Phil & Jim and discuss who should receive a bonus based on performance. For the manager not chosen, discuss the costs you would challenge to explain why you did not meet your goals

Phil Jim Corporate

Revenues 100,000.00 90,000.00

Fixed costs 8,000.00 6,000.00

VOH 45,000.00 32,000.00

DM 15,000.00 12,000.00

DL 9,000.00 12,000.00

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Q:

Edge Soccer Program (Edge) began the year with a cash balance of $10,500. The budget forecasts that collections from customers owed to the company will be $11,000 in January and $15,200 in February....

Q:

Create a manufacturing company. Using EXCEL, create the sales budget, production budgets), and the income statement. State any assumptions used to create budgets. Explain the steps necessary to build...

Q:

Phil and Jim were roommates in college and have always competed against each other. Since graduating from college, both men were hired at the same company. The company pays bonuses at the end of year...

Q:

Written Assignment - ACC 300 Phil and Jim were roommates in college and have always competed against each other. Since graduating from college, both men were hired at the same company. The company...

Q:

Written Assignment - ACC 300 Phil and Jim were roommates in college and have always competed against each other. Since graduating from college, both men were hired at the same company. The company...

Q:

Phil and Jim were roommates in college and have always competed against each other. Since graduating from college, both men were hired at the same company. The company pays bonuses at the end of year...

Q:

Assignment Overview The goal is to determine which manager achieved the performance goals set by the organization. Achieving organizational goals also determine how well the managers supported the...

Q:

Assignment Overview The goal is to determine which manager achieved the performance goals set by the organization Achieving organizational goals also determine how well the managers supported the...

Q:

Phil and Jim were roommates in college and have always competed against each other. Since graduating from college, both men were hired at the same company. The company pays bonuses at the end of year...

Q:

Written Assignment - ACC 300 Phil and Jim were roommates in college and have always competed against each other. Since graduating from college, both men were hired at the same company. The company...

Q:

Managerial Accounting: Master Budget Question Zigby Manufacturing prepared the following estimated balance sheet for March 2017: To prepare a master budget for April, May, and June of 2017,...

Q:

Given a random sample X1,..., Xn from a population with pdf f(x|), show that maximizing the likelihood function, L(|x), as a function of is equivalent to maximizing log L(|x).

Q:

Your pharmaceutical firm is seeking to open up new international markets by partnering with various local distributors. The different distributors within a country are stronger with different market...

Q:

The following information is available for Sheridan Corporation for the year ended December 3 1 , 2 0 2 2 . \ table [ [ Beginning cash balance,$ 4 8 , 0 0 0 ] , [ Accounts payable decrease, 3 , 9 0 0...

Q:

A biconvex lens is made of glass whose index of refraction is 1.6. The lens has a radius of curvature of 30 cm for one surface and 40 cm for the other. Calculate the focal length of this lens as used...

Q:

A bee produces a buzzing sound that is barely audible to a person 3.0 m away. How many bees would have to be buzzing at that distance to produce a sound with an intensity level of 50 dB?

Q:

A beam of red light is incident on an equilateral prism as shown in Fig. 22.31. (a) If the index of refraction of red light of the prism is 1.400, at what angle θ does the beam emerge...

Q:

A beam of protons is accelerated easterly from rest through a potential difference of 3.0 kV. It enters a region where there exists an upward pointing uniform electric field. This field is created by...

Q:

A beam of protons exits from a particle accelerator due east at a speed of 3.0 x 105 m/s. The protons then enter a uniform magnetic field of magnitude 0.50 T that is oriented at above 37o the...

Q:

What are the main documents operations mangers use for productions?

Q:

9. What is meant by the statement, the context is only relevant to us if we understand what it is trying to say?

Q:

7. What does it mean when we say that the words we use to denote a situation set limits on the solutions we can create at a later point?

Q:

8. Give examples from your own everyday life that the reference point you use has significance for the actions you take.