0Required informationYou have an Excel table with annual production targets for three factories. Each factory has an initial production target forQuarter 1 and a quarterly growth rate. Your task is to calculate the production targets for the remaining quarters using theformulas below:Annual Quarterlyproduction GrowthQ1Q2Q3Q4targetRateFactory X2005%150cell E2Factory Y 2207.5%180Factory Z 2506.25%140Quarter_2 = Quarter_1* (1 + Quarterly Growth Rate)Quarter_3=Quarter_2*(1+ Quarterly Growth Rate)Quarter_4 Quarter_3*(1+ Quarterly Growth Rate)Using appropriate reference types (relative, absolute, and mixed), create a formula in cell E2 to calculate the productiontarget for Factory X in Quarter 2. Then, extend this formula to calculate the production targets for all quarters for Factory Xand the other factories. (Hint: You must write only one formula that can generate all values in the table)Answer the next questions based on your results.Which factory will reach the annual production target?

Key Data:Factory X: Target = 200, Growth Rate = 5%, Q1 = 150Factory Y: Target = 220, Growth Rate =…

Answered: 0 Required information You have an…

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter7: Variable Costing For Management analysis

Section: Chapter Questions

Problem 15E

See similar textbooks

Similar questions

Two products X and Z are manufactured in a department. Sales for the year 2022 were planned as follows: Product Quarter 1 Quarter 2 Quarter 3 Quarter 4 X 8000 10000 11000 14000 Z 6000 8000 7500 5500 Selling prices in Quarter 1 were estimated as OMR 20 per unit for X and OMR 30 for Z respectively. Average sales return are 5% of Sales and 10% decrease in selling price in each quarter compared to previous one. According to these estimates, which of the following is estimated Sales (OMR) in Quarter 4 for Product X? Select one: a. 266000 b. 159600 c. 185600 d. 193914
Target Level of Endil с. 2. Given the following information, estimate the quarterly production in 2016. 450 000 units a. Inventories, December 31, 2015 b. Projected Quarterly Sales and Target Level of Ending Inventories in 2016: Target Level of Ending Inventories Quarter Projected Sales 500 000 Quarter 1 Quarter 2 Quarter 3 Quarter 4 3 500 000 4 500 000 500 000 5 000 000 1000 000 8 000 000 550 000 Requirements: Determine the production for each quarter in 2016. a. b. How many units are expected to be produced in 2016? С. How many units are expected to be sold in 2016?
Pleas include all steps of calculations for my reference. Thanks in advance. Required - Complete proforma income statement Q - Sales of existing products are expected to increase by 5% annually. Raw materials for existing products is expected to start at 30% of sales in 2022 but increase in subsequent years by 2% a year (32% of sales in 2023, 34% of sales in 2024 etc.). Labour costs are expected to remain at 15% of sales for all 5 years. Marketing costs are expected to increase by 2% in 2022 and then increase by a further $15 million in 2023 and a further $25 million in 2024 and then remain at that level for subsequent years. The corporate tax rate is expected to be 42% of net income before tax for all 5 years. NABM uses a declining balance depreciation policy. Equipment is depreciated at a rate of 20% while plant is depreciated at a rate of 10%. For planning purposes, Rachel has been advised to assume that normal plant additions for the five years will be $15 million per…
The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account):1st Quarter 2nd Quarter 3rd Quarter 4th QuarterBudgeted unit sales ............................ 11,000 12,000 14,000 13,000The selling price of the company’s product is $18.00 per unit. Management expects to collect 65% of salesin the quarter in which the sales are made, 30% in the following quarter, and 5% of sales are expected to beuncollectible. The beginning balance of accounts receivable, all of which is expected to be collected in thefi rst quarter, is $70,200.The company expects to start the first quarter with 1,650 units in finished goods inventory. Management desires an ending finished goods inventory in each quarter equal to 15% of the next quarter’s budgeted sales. The desired ending finished goods inventory for the fourth quarter is 1,850 units.Required:1. Prepare the company’s sales budget and schedule of expected cash…
Macom Manufacturing has total contribution margin of $61,250 and net income of $24,500 for the month of June. Marcus expects sales volume to increase by 10% in July. What are the degree of operating leverage and the expected percent change in income for Macom Manufacturing? 0.4 and 10% 2.5 and 10% 2.5 and 25% 5.0 and 50%
Wallace Industries has total contribution margin of $58,560 and net income of $24,400 for the month of April. Wallace expects sales volume to increase by 5% in May. What are the degree of operating leverage and the expected percent change in income for Wallace Industries? 0.42 and 2.2% 0.42and5% 2.4andl2% 2.Sandl3%
propose suggestions to improve
1. Multiplicationtable: (No need the explanation just the answer pls)A manufacturer has invested P750,000 in a new product and wants to set a price to earn a 15 percent ROI. The cost per unit is P18 and the company expects to sell 50,000 units in the first year. The company's target-return price for this product is P ______. a. 18.23 b.20.25 c.20.70 d.18.10 e.25.202. A ballpen manufacturer have the following costs and expected sales: Variable cost P 10.00 Fixed cost P300,000.00Expected unit sales 50,000 Break-even volume will be P______. a. 30,000 b. 35,000 c. 20,000 d. 25,000 3. If the cost of manufacturing a product is P30 and the item sells for P50, the markup percentage is _____ %. a. 67.7 b. 67.6 c. 66.7 d. 66.8
Give typed explanation The demand for a product in the past 10 months were: 636, 463, 738, 744, 555, 486, 667, 518, 450, 682 Suppose a four-month moving average method is used to generate forecasts. What is the forecasted demand in month 6? Use at least 4 decimal places.
Two articles A and B are manufactured in a department. Sales for the year 2021 were planned as follows: Product 1st 2nd 3rd 4th Quarter Quarter Quarter Quarter (Units) (Units) (Units) (Units) Product 50,000 60,000 65,000 75,000 A Product 25,000 22,500 20,000 19,000 B Selling price were sh. 40 per unit for A and sh. 20 per unit for B respectively. Average sales return is 5 % of sales. What is the annual sales budget for the year 2021? Select one: Sh 11,730,000 O Sh 11,143,500 Sh 9,500,000 O Sh 10,750,000
The financial data for 2017 and 2018 are presented in the table below. Use the data to calculate the total productivity measure and the partial measures for labor, capital, and raw materials for ABCD Company for the two years. Explain what each of measures tell you about this company 2 017 2018Output: Sales $300,000 $320,000Input: Labour 40,000 50,000Raw Materials 45,000 55,000Energy 6,000 7,000Capital 60,000 60,000Other 3,000 4,000
Suppose the marginal cost and marginal revenue (in ¢000) for a product produced by a company is estimated to be MC=q+35 MR=560+22q-q^2 Where q is the quantity produced and the firm’s break-even is 5 units per week You are Required to I. determine the total cost and the total revenue function in terms of q. II. estimate the output at which profit is maximize III. calculate the maximum profit

SEE MORE QUESTIONS

Recommended textbooks for you

Managerial Accounting

Accounting

ISBN:

9781337912020

Author:

Carl Warren, Ph.d. Cma William B. Tayler

Publisher:

South-Western College Pub

Financial And Managerial Accounting

Accounting

ISBN:

9781337902663

Author:

WARREN, Carl S.

Publisher:

Cengage Learning,

Principles of Accounting Volume 2

Accounting

ISBN:

9781947172609

Author:

OpenStax

Publisher:

OpenStax College

Managerial Accounting

Accounting

ISBN:

9781337912020

Author:

Carl Warren, Ph.d. Cma William B. Tayler

Publisher:

South-Western College Pub

Financial And Managerial Accounting

Accounting

ISBN:

9781337902663

Author:

WARREN, Carl S.

Publisher:

Cengage Learning,

Principles of Accounting Volume 2

Accounting

ISBN:

9781947172609

Author:

OpenStax

Publisher:

OpenStax College

Principles of Cost Accounting

Accounting

ISBN:

9781305087408

Author:

Edward J. Vanderbeck, Maria R. Mitchell

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS