Please do not give solution in image format... And give solution in step by step... And give solution in table format and giving calculation also...... Complete this question by entering your answers in the tabs below. Required 1 Required 2 Prepare an income statementusing absorption costing based on production of 19,375 tons and sales of 15,500 tons. Can the company report apositive income by increasing production to 19,375 tons and storing the 3,875 tons of excess production in inventory?Note: Round your answers to the nearest whole dollar. Show less A 33315ntsComplete this question by entering your answers in the tabs below.Required 1 Required 2eBookShow less▲APrinteferencesPrepare an income statement using absorption costing based on production of 19,375 tons and sales of 15,500 tons. Can thecompany report a positive income by increasing production to 19,375 tons and storing the 3,875 tons of excess production ininventory?Note: Round your answers to the nearest whole dollar.BLAZER CHEMICALIncome Statement (Absorption Costing)Sales$1,240,000Cost of goods soldGross profit232,5001,007,500DSelling general and administrative expensesIncome$1,007,500Did the company report a positive income?Yes< Required 1Required 2 >

1. **Cost per Ton Calculation**: - Given the Cost of Goods Sold (COGS) is $232,500 and Sales is…

Answered: Complete this question by entering your…

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter22: Master Budget (master)

Section: Chapter Questions

Problem 6R

See similar textbooks

Similar questions

Complete this question by entering your answers in the tabs below. Required A Required B Assume that only one product is being sold in each of the four following case situations: (Loss amounts should be indicate a minus sign.) Units sold Sales Variable expenses Contribution margin Fixed expenses Net operating income (loss) Contribution margin per unit $ $ Case 1 8,400 243,600 168,000 75,600 90,000 Case 2 $ 366,600 $ 9 $ Required A 163,000 34,400 $ 14 $ Case 3 19,300 173,700 $ 186,200 $ 14 Required B Case 4 5,500 165,000 80,000 (25,000)
Stuart Company operates three segments. Income statements for the segments imply that profitability could be improved if Segment A were eliminated. Segment Sales Cost of goods sold Sales commissions Contribution margin. General fixed operating expenses (allocation of president's salary) Advertising expense (specific to individual divisions) Net income (loss) Complete this question by entering your answers in the tabs below. Required A Required B STUART COMPANY Income Statements for Year 2 Prepare a schedule of relevant sales and costs for Segment A. Relevant Rev. and Cost items for Segment A Sales Cost of goods sold Sales commissions Advertising expense Effect on income Required a. Prepare a schedule of relevant sales and costs for Segment A. b. Prepare comparative income statements for the company as a whole under two alternatives: (1) the retention of Segment A and (2) the elimination of Segment A. $ $ 163,000 (128,000) (17,000) 0 B $242,000 $256,000 (78,000) (28,000) (86,000)…
a. Present a cost-profit-volume analysis that shows the effect of adding the $8,500 annual premium to the company's fixed costs by showing current and revised CVP Income Statements. Include a column to the right of each income statement where each line item is expressed as a percentage of sales (called a common size income statement). b. Visualize the changes to net income in a chart. c. Advise the company using your quantitative support and qualitative. reasoning as to whether the company should purchase the insurance. A-Float Pools Company Income Statement (Pools Maintenance Div.) For the Year Ended December 31, 2022 In Sales (2,000 clients) Cost of Services Gross profit Operating expenses Selling Administrative Net Income $165,000 $225,000 $1,100,000 627,000 $473,000 $390,000 $83.000
Smithen Company, a wholesale distributor, has been operating for only a few months. The company sells three products-sinks, mirrors, and vanities. Budgeted sales by product and in total for the coming month are shown below based on planned unit sales as follows: Sinks Mirrors Vanities Total Units 1,000 500 500 2,000 Percentage of total sales Sales Variable expenses Contribution margin Contribution margin per unit Fixed expenses Operating income Break-even point in unit sales: Percentage sex 25% 25% 100% Break-even point in sales dollars: Total Fixed expenses. Weighted-average CM per unit Sinks 48% Product Mirrors 20% $264,000 100.00% $110,000 100.00% $176,000 100.00% $550,000 100.00% 80,000 30.30% 72,000 65.45% 82,000 46.59% 219,300 39.87% 53.41% 60.13% $184,000 $ 94,000 330,700 69.70% 38,000 34.55% S 76.00 $ 184.00 $ 188.00 Fixed expenses Overall CM ratio $293,300 $158.00 Vanities 32% $293,300 0.60 1,856.33 units Total 100% 293,300 $ 37,400 = $487,798.61 *($184.00 0.50) + ($76.00 x…
Jordan Cameras, Incorporated manufactures two models of cameras. Model ZM has a zoom lens; Model DS has a fixed lens. Jordan uses an activity-based costing system. The following are the relevant cost data for the previous month: Direct Cost per Unit Direct materials Direct labor Category Unit level Batch level Product level Facility level Total Estimated Cost $ 25,960 49,920 90,000 180,000 $ 345,880 Model ZM $ 20.70 29.40 Cost Driver Model DS $7.00 9.00 Number of units Number of setups Number of TV commercials Number of machine hours Amount of Cost Driver ZM: 2,500 units; DS: 9,300 units ZM: 26 setups; DS: 26 setups ZM: 14; DS: 11 ZM: 300 hours; DS: 600 hours Jordan's facility has the capacity to operate 2,700 machine hours per month. Required a. Compute the cost per unit for each product. b. The current market price for products comparable to Model ZM is $118 and for DS is $68. If Jordan sold all of its products at the market prices, what was its profit or loss for the previous month?…
Fill in the missing amounts in each of the eight case situations below. Each case is independent of the others. (Hint: One way to find the missing amounts would be to prepare a contribution format income statement for each case, enter the known data, and then compute the missing items.) Required: a. Assume that only one product is being sold in each of the following four case situations: Unit sold Sales Variable expenses Foxed expenses Operating income (loss) Contribution margin per unit $ Case #1 15,000 180,000 $ 100,000 120,000 50,000 $ $ Case #2 Case #1 Case #3 10,000 Case #2 70,000 $ 32,000 8,000 $ 12,000 $ 10 $ 13 Case #4 b. Assume that more than one product is being sold in each of the following four case situations: (Enter "Contribution margin ratio" in percent. Round your final answers to the nearest whole dollar amount.) Case #3 6,000 300,000 100,000 (10,000) Case #4
Keep-Or-Drop Decision, Alternatives, Relevant Costs Reshier Company makes three types of rug shampooers. Model 1 is the basic model rented through hardware stores and supermarkets. Model 2 is a more advanced model with both dry-and wet-vacuuming capabilities. Model 3 is the heavy-duty riding shampooer sold to hotels and convention centers. A segmented income statement is shown below. Model 1 Model 2 Total Model 3 $631,000 Sales $260,000 $598,000 $1,489,000 Less variable costs of goods sold (89,000) (162,320) (336,400) (587,720) Less commissions (4,100) (38,000) (20,500) (62,600) Contribution margin $166,900 $397,680 $274,100 $838,680 Less common fixed expenses: Fixed factory overhead (405,000) Fixed selling and administrative (303,000) Operating income $130,680 While all models have positive contribution margins, Reshier Company is concerned because operating income is less than 10 percent of sales and is low for this type of company. The company's controller gathered additional…
Complete this question by entering your answers in the tabs below. Req 1A Req 1B Req 2A Req 2B Assuming the sales mix given above, prepare a contribution format income statement showing both dollar and percent columns for e for the company as a whole. $ Island Novelties, Inc., Contribution Income Statement Hawaiian Fantasy Amount % 0 % % 0% $ Total Amount 0 0 % % % 0 %
As a costing team member, calculate the gross profit if: Sales P6,000; Cost of Sales P5,000; Beginning Inventory P1,000; Purchases P4,000; Wages P2,000; and Office Rent P1,000?a. Loss = P2,500b. Loss = P1,500c. Profit = P2,500d. Profit = P1,000
APPLY THE CONCEPTS: Target income (sales revenue) Another useful method for figuring out the type of performance your company will need to reach a target income is by using sales revenue. Rather than using the number of units, this method uses total sales revenue. In companies for which the total set of goods produced and sold is more varied, this would be the preferred method, as opposed to a business in which only one product is sold. Assume a company has pricing and cost information as follows: Price and Cost Information Amount Selling Price per Unit $30 Variable Cost per Unit $15 Total Fixed Cost $15,000 For the upcoming period, the company wishes to generate operating income of $40,000. Given the cost and pricing structure for the company's product, how much sales revenue must it generate to attain its target income? Step 1: Calculate the contribution margin ratio: The contribution margin ratio is the contribution margin in proportion to the selling price on a per-unit basis.…
Compute gross profit earned by the company for each of the four costing methods. (Round your average cost per unit to 2 decimal places and final answers to nearest whole dollar.) FIFO LIFO Weighted Average Specific Identification Sales Less: Cost of Goods Sold Gross Profit Side Note: Image 2 highlighted with pink (Table (c) Average Cost) is the only numbers/entries that are wrong and needs to be corrected.
b) Write Excel Formulas for given data sheet A B D E 1 Product Product Price per Sales tax(10% |Net Price No item of price) ? name 2 1 Mouse 5000 keyboard joyStick 3 1000 4 3 1500 4 VGA cable 800 6. Monitor 15000 Total price of all items 5% concession on total price 7 ? 8 ? 9. Total bill ? Dage 213

SEE MORE QUESTIONS

Recommended textbooks for you

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

Publisher:

Cengage Learning

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS