AC Project3 calculations

30

K16 1 2 3 # 5 3 Projected Sales Volume 3 Desired Ending Inventory 9 0 Units Needed 1 Beginning Inventory 2 3 Projected Production 4 5 6 7 L8SOT 9 0 A 1 fx B с Paulson Paint, Inc Production Budget For the Year Ended December 31, 2019 Magnificent Paint 435,000 36,000 33,500 D E Marvelous Paint 338,154 29,000 25,890 F Total G H

Multiple choice pls answer numbers 4 to 8

A 2 Category 3 Sales 4 Cost of Goods Sold 15 a. Calculate ROA for current values. 16 Note: Round your answers to 2 decimal places. 17 18 SPM Outputs 19 Gross Profit 20 B Current Input Values $3,237,000.00 $2,490,000.00 $415,000.00 $161,850.00 $465,000.00 $162,000.00 $546,000.00 $492,000.00 5 Variable Expenses 6 Fixed Expenses 7 Inventory 8 Accounts Receivable 9 Other Current Assets 10 Fixed Assets 11 12 Required: 13 Note: Use cells A2 to C10 from the given information to complete this question. 14 Total Expenses 21 Net Profit 22 Net Profit Margin 23 Current Assets 24 Total Assets 25 Asset turnover 26 ROA (%) 27 28 b. Calculate ROA for new values. 29 Note: Round your answers to 2 decimal places. 30 31 SPM Outputs 32 Gross Profit 33 Total Expenses 34 Net Profit 35 Net Profit Margin 36 Current Assets 37 Total Assets 38 Asset turnover 39 ROA (%) 40 41 42 C New Input Values $3,560,700.00 $2,490,000.00 $383,875.00 $161,850.00 $395,250.00 $162,000.00 $546,000.00 $492,000.00 D E F TI G H I J K…

Date Date 1/9/18 10/9/18 Dollar Rate Dollar Rate 1,16 Price in Euros Price in Dollars Price in Dollars Difference 1,18 Model 300 VRG 625 RTM 475 GRM 200 GRM 650 MTY 600 RTM 500 MTY 46.900 € $55.342 $54.404 $938 66.700 € $78.706 $77.372 $1.334 96.100 € 122.600 € 164.900 € 214.400 € 247.300 € $113.398 $111.476 $1.922 $144.668 $142.216 $2.452 $194.582 $191.284 $3.298 $252.992 $291.814 $248.704 $286.868 $4.288 $4.946 1) Most of your exports to the US belong to the model 600 RTM. The experience shows that, if the price of this product rises over 215000 dollars, the exported units will be reduced. If this product is priced in euros, and assuming the trend shown in question 1 continues, what would be the consequences for your company's exports?

00 Chapter 1 PROBLEM 1-19 Traditional and Contribution Format Income Statements L01-6 Todrick Company is a merchandiser that reported the following information based on 1,000 units sold: Sales..... Beginning merchandise inventory. Purchases..... 1. 2. 3. 4. 5. 6. Ending merchandise inventory Fixed selling expense...... Fixed administrative expense. Variable selling expense. Variable administrative expense Contribution margin. Net operating income $300,000 $20,000 $200,000 $7,000 ? $12,000 $15,000 ? $60,000 $18,000 Required: Prepare a contribution format income statement. Prepare a traditional format income statement. Calculate the selling price per unit. Calculate the variable cost per unit. Calculate the contribution margin per unit. Which income statement format (traditional format or contribution format) would be more useful to managers in estimating how net operating income will change in responses to changes in unit sales? Why?

Use Goal Seek to find the new price per box (cell K8) to reach a new daily average sales goal of $3,000 in cell K7. Accept the solution found by Goal Seek.

Question 16 /1 View Policies Current Attempt in Progress If the required direct materials purchases are 32000 pounds, the direct materials required for production is three times the direct materials purchases, and the beginning direct materials are three and a half times the direct materials purchases, what are the desired ending direct materials in pounds? oport 48000 O 32000 O 80000 O 16000 ) hp prt sc delete home % 6 num backspace lock P home K enter pause tn tn USE YOUR SMARTPHONE FOR M I

QUESTION 6 2 what is the Mark up dollars? Retail $25.00 Cost Markup 38%

< Cost Flow Methods The following three identical units of Item JC07 are purchased during April: Units Cost April 2 April 15 April 20 Total Item Beta Purchase Purchase Purchase a. First-in, first-out (FIFO) b. Last-in, first-out (LIFO) c. Weighted average cost 1 1 1 3 $94 97 Gross Profit 100 $291 Average cost per unit ($291 + 3 units) Assume that one unit is sold on April 27 for $120. Determine the gross profit for April and ending inventory on April 30 using the (a) first-in, first-out (FIFO); (b) last-in, first-out (LIFO); and (c) weighted average cost method. $97 Ending Inventory $

4. Size of Accounts Receivable [LO1] Skye Flyer, Inc., has weekly credit sales of $21,900, and the average collection period is 33 days. What is the average accounts receivable figure?

レ %24 B5 Chapter 10 Lab application-A X Bb Chapter 10 Lab application -A X * CengageNOWv2 | Online teach x keAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogre... * eBook Show Me How The following information is taken from a company's records. Cost Market value per Unit per Unit Inventory Item 1 (9 units) $32 $31 Inventory Item 2 (21 units) 6 - 6- Inventory Item 3 (12 units) 9. 8. Applying the lower-of-cost-or-market approach, what is the correct value that should be reported on the balance sheet for the inventory? S7IOIA Show All Check Mv Work 4 more Check My Work uses remainina Sample Proble....docx Sample Proble...docx Proble....docx

Exercise 5-12 The president of Normolle Mfg. Co. which manufactures only one product, requests an analysis of the causes of the change in gross profit. An investigation reveals the following: Sales Cost of Sales Gross Profit 2020 Amount P1,224,000 700,800 P523,200 Per Unit P10.20 5.84 P4.36 2019 Amount P1,000,000 600,000 P400,000 Per Unit REQUIRED: 1. A detailed analysis of the causes for the change in gross profit graphically. P10.00 6.00 P4.00

+ I/ An V - MI * 00 關 因 T F. PR 44 %#3 @https://ezto.mheducation.com/ext/map/index.html?_con3Dcon&e dit - Chapter 11 & 13 Review Saved Help Save & Exit The Colson Company has budgeted sales for the year as follows: 1. 13,300 15,300 19,200| 17,300 Quarter 2 Sales in units The ending inventory of finished goods for each quarter should equal 25% of the next quarter's budgeted sales in units. The finished goods inventory at the start of the year is 4,300 units. Scheduled production for the third quarter is (in units) Multiple Choice 18,725 units. O 19,675 units. Graw < Prev 16 of 20 Next 11!H pe here to search 近 Dツ +D F-4 F7 PrtSc F10 F11 Dele 65 F12 Ins 23 & 2. 9. 6 S G N Alt Ctrl

Chapter 5(1) i 12 Part 10 of 15 1 points eBook Print References ! Required information The Foundational 15 (Algo) [LO5-1, LO5-2, LO5-3, LO5-4, LO5-5, LO5-6, LO5-7] [The following information applies to the questions displayed below.] Sales Variable expenses Contribution margin Fixed expenses Net operating income Oslo Company prepared the following contribution format income statement based on a sales volume of 1,000 units (the relevant range of production is 500 units to 1,500 units): Number of units ezto.mheducation.com $ 15,000 9,000 80 Saved 6,000 3,120 $ 2,880 Foundational 5-10 (Algo) 10. How many units must be sold to achieve a target profit of $3,600? Note: Round intermediate calculations to 2 decimal places. 0 Help Save & Ex Chec

7:34 ll 5G e Ims.trainingcertificationedge.com-Private 1:49:40 REMAINING O Question 7 of 100 Which of the following statements about the interrelationships of volume and price is TRUE? A. Price increases raise the percentage of variable costs to sales. B. Volume increases lower the variable cost percentage. C. Price increases reduce variable costs. D. Volume increases raise variable costs.

Question number 17

LL Cost per bag $1.00 $1.50 $2.00 600,000 $2.75 400,000 Bags sold Profit 1,500,000 800,000 A. $1.50 per bag C. $2.75 per bag per bag $0.20 $0.35 $0.60 $0.85 Which of the 4 price options listed in the table will maximize the total profit made by a potato chip manufacturer? A 9 a B. $1.00 per bag D. $2.00 per bag Copyright © 2003-2022 International Academy of Science. All Rights Reserved. H 4x

complete the table?

vnt.6

Sites JESS Time Remaining: 01:04:03 A Hide Time Remaining A Part 1 of 2- Question 5 of 50 1 Points The budget of a company for next period shows that it would breakeven at a sales value of GHC800000 with fixed cost of GH¢320000. What sales value should the company target to derive a profit of GH¢200000 in the next period? O A. GHC1320000 OB. GHC1300000 OC. GHC1000000 O D. GHC866667 Reset Selection 11:59 3/18/2 Ps

compute highlighted cells using the LIFO method A B E F G Units in Cost per unit Total cost Units H Selling Total Sales price per K unit 6 January 01 Beginning inventory 210 $13.50 $2,835.00 7 January 10 Sales 160 $22.50 $3,600.00 8 January 20 Purchase 150 $12.50 $1,875.00 9 January 25 Sales 180 $22.50 $4,050.00 10 January 30 11 Purchase Totals 340 $12.00 $4,080.00 700 $8,790.00 340 $7,650.00 12 13 Perpetual LIFO 14 Units available Cost of Goods Sold - Jan 10 Units Cost Cost of per unit goods sold Cost of Goods Sold - Jan 25 Units Cost Cost of Ending Inventory Units Cost Invento per unit goods sold per unit 15 210 units from beginning inventory $13.50 $13.50 $13.50 16 150 units purchased on January 20 $12.50 $12.50 $12.50 17 340 units purchased on January 30 $12.00 $12.00 $12.00 18 Totals 0 $0.00 ° $0.00 ° $0 19 an

Answer ALL FOUR Questions Question 12 Total Pop's data show the following information of January, February, March, April, May 2022 (respectively): ♦ + Additional information Finished goods inventory is required to be 20% of the next month's . Jan. Feb. Mar. Apr. May Estimated sales (units) 15,000 14,500 16,000 15,500 15,800 Sales price per unit $ 45 $ 45 $ 45 S 45 $ 45 Direct labor per unit $ 3 $ 3 $2.25 S 2 $ Labor rate per hour $ 18 $ 18 S 21 $ 21 S 2 21 requirements. The ending inventory required for direct materials is 15% of the next month's needs. Direct material requires 2 pounds per unit at a cost of $3 per pound. In January, the beginning inventory is 3,000 units of finished goods and 4,470 pounds of material. Required: Prepare the below budgets for the company: (a) a production budget for the first quarter of the year. (b) direct materials budget for the first quarter of the year. X

69 %24 Cost Flow Methods The following three identical units of Item JC07 are purchased during April: Item Beta Units Cost April 2 Purchase $317 April 15 Purchase 1. 318 April 20 Purchase 319 Total $954 Average cost per unit $318 ($954 3 units) Assume that one unit is sold on April 27 for $439. Determine the gross profit for April and ending inventory on April 30 using the (a) first-in, first-out (FIFO); (b) last-in, first-out (LIFO); and (c) weighted average cost method. Gross Profit Ending Inventory a. First-in, first-out (FIFO) b. Last-in, first-out (LIFO) C. Weighted average cost Check My Work

Image answer me

3-36. CONTRIBUTION MARGIN, GROSS MARGIN, AND MARGIN www OF SAFETY. Bella Beauty manufactures and sells a face cream to small specialty stores in the greater Los Angeles area. It presents the monthly operating income statement shown here to George Sanchez, a potential investor in the business. Help Mr. Sanchez understand Bella Beauty's cost structure. Required 1. Recast the income statement to emphasize contribution margin. 2. Calculate the contribution margin percentage and breakeven point in units and revenues for June 2020. 3. What is the margin of safety (in units) for June 2020? 4. If sales in June were only 9,500 units and Bella Beauty's tax rate is 30%, calculate its net income.

A1 fx Chapter 6: Ap B D E Chapter 6: Applying Excel 3 Data 4 Selling price per unit 5 Manufacturing costs: 6 Variable per unit produced: Direct materials $50 7 $11 8 Direct labor $6 $3 Variable manufacturing overhead 10 Fixed manufacturing overhead per year 11 Selling and administrative expenses: 12 Variable per unit sold 13 Fixed per year 9 $120.000 $4 S70,000 14 15 Year 1 Year 2 16 Units in beginning inventory 17 Units produced during the year 18 Units sold during the year 10,000 6.000 8,000 6,000 19 20 Enter a formula into each of the cells marked with a ? below 21 Review Problem 1: Contrasting Variable and Absorption Costing 22 23 Compute the Ending inventory 24 Year 1 Year 2 25 Units in beginning inventory 26 Units produced during the year 27 Units sold during the year 28 Units in ending inventory 2,000 6,000 6,000 10,000 8.000 2,000 2,000 29 30 Compute the Absorption Costing Unit Product Cost Year 1 $11 31 Year 2 $11 32 Direct materials 33 Direct labor 34 Variable manufacturing…

Question 42 of 50 く -/1 View Policies Current Attempt in Progress Concord Corporation began using dollar-value LIFO for costing its inventory last year. The base year layer consists of $601000. Assuming the current inventory at end of year prices equals $831000 and the index for the current year is 1.2, what is the endinɛ inventory using dollar-value LIFO? O $831000. O $710800. O $997200. O $692500. Save for Later Attempts: 0 of 2 used Submit Answer

None

Sh12 Please help me  Solution  Thankyou

Arial 10 v A A 2 Wrap Text v General $ v % 9 00 0 Conditional Format, Formatting as Table Styles Cell Paste BIUV v A v 2 Merge & Center v .00 39 Xv fx B E F G H 1 Evergreen Fertilizer Company produces fertilizer. The company's fixed monthly cost is $25,000.00, and its variable per pound of fertilizer is $0.15. Evergreen sells the fertilizer for $0.40 per pound. cost 4 a) Determine the break-even volume for the company. What is the Contribution Margin? 6 b) If Evergreen Fertilizer Companychanges the price of its fertilizer from $0.40 per pound to $0.60 per pound. Wha will the change have on the break-even volume. What is the Contribution Margin? 7 t effect 8 9 c) Using the price of $0.60 per pounds, if Evergreen Fertilizer Companyc hanges its production process to ad a we killer to the fertilizer in order to increase sales, the variable cost per pound will increase from $0.15 to $0.22. What 10 eed 11 t effect 12 will this change have on the break-even volume. 13 d) If Evergreen…

Question Content Area Present value of $1 Periods 6% 8% 10% 12% 14% 16% 1 0.94340 0.92593 0.90909 0.89286 0.87719 0.86207 2 0.89000 0.85734 0.82645 0.79719 0.76947 0.74316 3 0.83962 0.79383 0.75131 0.71178 0.67497 0.64066 4 0.79209 0.73503 0.68301 0.63552 0.59208 0.55229 5 0.74726 0.68058 0.62092 0.56743 0.51937 0.47611 6 0.70496 0.63017 0.56447 0.50663 0.45559 0.41044 7 0.66506 0.58349 0.51316 0.45235 0.39964 0.35383 8 0.62741 0.54027 0.46651 0.40388 0.35056 0.30503 9 0.59190 0.50025 0.42410 0.36061 0.30751 0.26295 10 0.55839 0.46319 0.38554 0.32197 0.26974 0.22668 Present value of an annuity of $1 Periods 6% 8% 10% 12% 14% 16% 1 0.94340 0.92593 0.90909 0.89286 0.87719 0.86207 2 1.83339 1.78326 1.73554 1.69005 1.64666 0.74316 3 2.67301 2.57710 2.48685 2.40183 2.32163 0.64066 4 3.46511 3.31213 3.16987 3.03735 2.91371 0.55229 5 4.21236 3.99271 3.79079 3.60478 3.43308 0.47611 6 4.91732 4.62288 4.35526 4.11141 3.88867 0.41044 7 5.58238 5.20637…

A9