BE6.3 -Using Excel to Create a Production Budget PROBLEM Filling in for his supervisor, who suddenly...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
BE6.3 -Using Excel to Create a Production Budget PROBLEM Filling in for his supervisor, who suddenly left the company, Harvey quickly evaluated the situation to wrap up his department's production budget. The department currently holds enough inventory to be in compliance with its standard which is based on the following month's budgeted sales. From the sales and previous budgets, he learned the budgeted unit sales for the next 4 months and the standard for holding inventory at month end which are both presented here. Unit sales per month Month 1 Month 2 Month 3 Month 4 Ending inventory standard Materials held at month end 5,000 4,500 6,000 6,500 10% Student Work Area Required: Provide input into cells shaded in yellow in this template. Input the required mathematical formulas or functions with cell references to the Problem area or work area as indicated. Show the production budget that Harvey would assemble for the next quarter. Month 3 Month 1 5,000 Month 2 4,500 Budgeted sales volume Target ending FG Inventory Total units needed Beginning FG Inventory Budgeted units to be produced ▼ ▼ 6,000 ▼ Quarter ▼ ▼ BE6.3 -Using Excel to Create a Production Budget PROBLEM Filling in for his supervisor, who suddenly left the company, Harvey quickly evaluated the situation to wrap up his department's production budget. The department currently holds enough inventory to be in compliance with its standard which is based on the following month's budgeted sales. From the sales and previous budgets, he learned the budgeted unit sales for the next 4 months and the standard for holding inventory at month end which are both presented here. Unit sales per month Month 1 Month 2 Month 3 Month 4 Ending inventory standard Materials held at month end 5,000 4,500 6,000 6,500 10% Student Work Area Required: Provide input into cells shaded in yellow in this template. Input the required mathematical formulas or functions with cell references to the Problem area or work area as indicated. Show the production budget that Harvey would assemble for the next quarter. Month 3 Month 1 5,000 Month 2 4,500 Budgeted sales volume Target ending FG Inventory Total units needed Beginning FG Inventory Budgeted units to be produced ▼ ▼ 6,000 ▼ Quarter ▼ ▼
Expert Answer:
Answer rating: 100% (QA)
1 Working Notes Prepared Working Notes Month 1 Month 2 Month 3 Mon... View the full answer
Related Book For
Fundamentals of Investing
ISBN: 978-0133075359
12th edition
Authors: Scott B. Smart, Lawrence J. Gitman, Michael D. Joehnk
Posted Date:
Students also viewed these accounting questions
-
Paula Corporation reports the following for this month: The beginning inventory is 30 units. It produces 140 units during this month. And 150 units are sold at $3,000 each. The budgeted level of...
-
From Kamal company information below; Debt, D = 30,000. Equity, E = 70,000. Cost of Debt rD = 8%. Cost of Equity, rE = 10%. Corporate Tax, Tc = 30 %. What is the weighted average Cost of Capital...
-
18. Equal volumes of two solutions containing 3.65g of HCl and 4.0 g of NaOH respectively are mixed. The pli of the mixture is 2) <7 3) >7 19. When Imi of 0.IN HCIIS added to 1 litre of a solution of...
-
Lever Age pays an 8% rate of interest on $10 million of outstanding debt with face value $10 million. The firm's EBIT was $1 million. a. What is times interest earned? b. If depreciation is $200,000,...
-
Tyler Jones, a management accountant for Pegstone Cosmetics Company, has lunch every day with his friend Joe Blaik, who is a management accountant for Shepherd Cosmetics, Inc., a competitor of...
-
A machine costs 5,120. It will be kept for five years, and then sold at an estimated figure of 1,215. Show the calculations of the figures for depreciation for each year using (a) the straight line...
-
Arial Company maintains a petty cash fund for small expenditures. The following transactions occurred over a 2-month period. July 1 Established petty cash fund by writing a check on Coulter Bank for...
-
JSON-3096 Inc. produces Products X5, Y8, and 29. The following table provides per unit information relating to the three products: X5 Product Y8 Selling price Variable expenses: Direct materials....
-
Pat and Mandy are married and have a son, Steve, age 8. Mandy, age 29, earns $40,000 annually from her job. Pat, age 31, earns $50,000 annually from his job. Assume that Pat will die before Mandy....
-
Sales-Value-at-Split-off MethodAlomar Company manufactures four products from a jointproduction process: barlon, selene, plicene, and corsol. The jointcosts for one batch are as follows:Direct 2...
-
Leadership & Motivation Identify the leadership traits, skills, and behaviors that you consider the most important in leading and motivating subordinates. Examine specifically why you selected the...
-
Imagine your class discussing motivation and Maslow's hierarchy of needs. You begin to think about which need is the most important for you to fulfill through a job after you graduate. Your...
-
Design strategies to increase employee motivation during times of change. Facebook's current implementation and evaluation plans Evaluate the role of leadership in developing an innovative culture....
-
K A random sample of 860 births in a state included 427 boys. Construct a 95% confidence interval estimate of the proportion of boys in all births. It is believed that a all births, the proportion of...
-
Project Topic: motivation strategy for multigenerational workforce in a global context
-
During 2019 (its first year of operations) and 2020, Fieri Foods used the FIFO inventory costing method for both financial reporting and tax purposes. At the beginning of 2021, Fieri decided to...
-
Make an argument that Williams had a right to delay the closing until after August 1.
-
For each of the following initial investment amounts, calculate the future value at the end of the given investment period if interest is compounded annually at the specified rate of return over the...
-
What is a satisfactory investment? When the present value of benefits exceeds the cost of an investment, what can you conclude about the rate of return earned by the investor relative to the discount...
-
Referring to Problem, using the portfolio beta, what would you expect the value of your portfolio to be if the market rallied 20%? Declined 20%? In problem assume you have a portfolio with $20,000...
-
Assuming the same information in Brief Exercise 18-25, record the income tax journal entry on December 31, 2020. Assume zero beginning balances in deferred tax accounts and there are no other...
-
Assume Company A and Company B each had a balance in deferred tax assets of \(\$ 250,000\). However, Company A has a valuation allowance related to the deferred tax asset of \(\$ 200,000\) while...
-
Maui Resort Inc. determined that the balance in its deferred tax asset account on December 31, 2020, was \(\$ 50,000\). Management reviewed all available positive and negative evidence to estimate...
Study smarter with the SolutionInn App