Cox Electric makes electronic components and has estimated the following for a new design of one of its products: Fixed Cost $10,000 Material cost per unit = $0.15 Labor cost per unit = $0.10 Revenue per unit = $0.65 Show Transcribed Text Implement your model from part (b) in Excel using the principles of good spreadsheet design and find the profit if Cox Electric makes 18,000 new product. If required, round your answer to nearest whole number. For subtractive or negative numbers use a minus sign. (Example: -300)
Q: Huluduey Corporation's comparative balance sheet for current assets and liabilities was as follows:…
A: The objective of the question is to calculate the net cash flows from operating activities for…
Q: Consider the following data: x -7 -6 -5 -4 -3 P(X = x) 0.2 0.1 0.2 0.1 0.4 Step 1 of 5: Find the…
A: The objective of the question is to calculate the expected value of a random variable X. The…
Q: A corporation commences operations on January 1, 2019. It has the following account balances at…
A: The objective of the question is to calculate the total net assets of the corporation at the end of…
Q: 1,060 Other 1, 196 Total expense 19,046 Net operating income $ 7,754 Required: Calculate the…
A: Variance analysis is a tool used in management accounting. In this, we calculate the deviations of…
Q: InterSteel gathered the following fair value data at year end, record any necessary journal entries:…
A: JAK Inc. Stock:Debit: Fair Value Adjustment (JAK Inc. Stock) $47,600Credit: Unrealized Gain/Loss -…
Q: For the transaction of the purchase of common stock, why are we debiting cash and crediting the…
A: The Total Stockholders Equity is the value of the total capital/equity of the owners of the entity.…
Q: dont provide handwriing solution...
A: The objective of the question is to calculate the sales budget for Beatrice Company for the fourth…
Q: Given the information below, what is the gross profit? Sales revenue Accounts receivable Ending…
A: Gross profit is the amount of money earned by the entity after deducting cost of goods sold from the…
Q: Polaski Company manufactures and sells a single product called a Ret. Operating at capacity, the…
A: The relevant cost refers to the cost which differs between the two alternatives or which is…
Q: Nicanor is a married man with surviving spouse: Community Properties: Real Property located in…
A: Gross Estate refers to the value of the property owned by the person which is the amount that…
Q: None
A: Inventory means the item in which the business deals. Inventory has to be valued at the end of…
Q: Direct Materials Purchases Budget Zippy's Frozen Pizza Inc. has determined from its production…
A: Direct materials purchase budget:DoughTomatoCheeseTotalUnits required for production:12" pizza7,980…
Q: Riley Company borrowed $32,000 on April 1, Year 1 from Titan Bank. The note issued by Riley carried…
A: $33,920 and $0Explanation:To determine the amounts of total liabilities that would appear on Riley's…
Q: what would be the difference in gross margin between fifo and lifo cost flow assumptions
A: The difference in gross margin between FIFO (First-In, First-Out) and LIFO (Last-In, First-Out) cost…
Q: Instructions Prepare the journal entries required to establish the petty cash fund on October 1 and…
A: Petty Cash Fund :A petty cash fund is a small amount of cash kept on hand by a business or…
Q: None
A: Businesses might use incremental analysis to weigh the additional income from a customized order…
Q: None
A: Special ordersThe company receives special orders at a point in time when the company has to decide…
Q: The following transactions occur for the Hamilton Manufacturers. (a) Provide services to customers…
A: The accounting equation is a mathematical representation of financial transactions. The accounting…
Q: Businesswire.com reported a shortage of inventory for new and used cars during the pandemic mainly…
A: MACRS stands for Modified Accelerated Cost Recovery System. Depreciation expense refers to a…
Q: The balance sheet for Tactex Controls Inc., provincially incorporated in 2021, reported the…
A: Stockholder's Equity includes the amount shareholders contribute in the form of common stock,…
Q: lary 2, sold to Grey for $67,250 machinery with a carrying ount of $51,250. Grey is depreciating the…
A: Consolidated net income:Any entity or person's income which includes the income of parent company as…
Q: Shankar Company uses a perpetual system to record inventory transactions. The company purchases…
A: The accounting equation states that assets are equal to the sum of the liabilities and equity. The…
Q: The Newburg Flyers operate a major sports franchise from a building in downtown Newburg. The…
A: It is a financial ratio used to analyse the financial statements with respect to the profitability…
Q: per Month Revenue Job $ 279 rixea variable Component Component per Actual Total for February $…
A: Flexible budget performance report is a management report that compares actual results with budgeted…
Q: University Car Wash purchased new soap dispensing equipment that cost $234,000 including…
A: Depreciation Expenses are the expenses incurred on the wear and tear of the fixed assets. This is…
Q: Skull Company makes snowboards and uses the total cost method in setting product price. Its costs…
A: Cost volume profit analysis is the technique used by management for decision-making. The methods…
Q: Mason Company provided the following data for this year. Sales Direct labor cost Raw material…
A: The cost of goods manufactured includes the cost of goods that are finished during the period. The…
Q: The following information is taken from the balance sheet of Atlanta Company: Current assets…
A: 1.5 to 1Explanation:We compute it by dividing the current assets by the company's current…
Q: 10points eBook Print References Check my workCheck My Work button is now enabled Item 2…
A: The objective of this question is to record the journal entry for the sale of merchandise under a…
Q: Sunland Furniture Inc. expects to produce 4750 finished goods (FG) units (in tables) in October and…
A: PRODUCTION BUDGETProduction Budget is a Forecast of the Production for the Budgeted Peirod of an…
Q: An apartment building was acquired in 2014 by an individual taxpayer. The depreciation taken on the…
A: Unrecaptured § 1250 gain is an income tax provision. The unrecaptured § 1250 gain helps to recapture…
Q: Bramble Incorporated leases a piece of equipment to Marin Corporation on January 1, 2020. The lease…
A: When a renter receives a payment from the lessee for the use of an asset in exchange for monthly…
Q: Selected data for the consulting department of Austin Consulting, Inc., follow: Estimated consulting…
A: Factory overheads are the indirect manufacturing costs which are incurred in producing the goods.…
Q: Apr. 30: Damon Manufacturing is party to a patent infringement lawsuit of $160,000 Damon…
A: Contingent liabilities means that amount which may or may not become liability of the business, the…
Q: None
A: The income statement shows the net earnings of the entity, it also reports the revenues made with…
Q: The following is cost information for ABC Company: Month Total costs Total units January $ 33,000…
A: Lets understand the basics.In high low method, total cost are divided into variable and fixed costs.…
Q: Required: 1. Compute the underapplied or overapplied overhead. 2. Assume the company closes…
A: Manufacturing overhead: It is the indirect cost incurred as a part of manufacturing the products.…
Q: Erie Company manufactures a mobile fitness device called the Jogging Mate. The company's labor…
A: “Since you have posted a question with multiple sub-parts, we will solve first three sub-parts for…
Q: Answer the following questions 1. 2. A company has an inventory of 1,050 assorted parts for a line…
A: Since you have posted multiple questions, we will provide the solution only to the first question as…
Q: Crane Paints manufactures artist's oil paints. Each 40 ml tube of paint requires 5 minutes of direct…
A: The direct labor is one of the manufacturing costs incurred by a factory for the production of…
Q: Gig Harbor Boating is the wholesale distributor of a recreational sailboat. Management provided the…
A: Income statement is a financial statement that shows the profitability, total revenue and total…
Q: Required information [The following information applies to the questions displayed below.] Evergreen…
A: Depreciation : Accounting method wherein the cost of a tangible asset is spread over the asset's…
Q: Liama MacDonald just turned thirty years old. She is currently single. Liama has gross wages of…
A: Withhold tax can be said to be the amount deducted by the employer from the salary of the employee…
Q: Direct Labor Variances The following data relate to labor cost for production of 4,700 cellular…
A: Direct labor variance is the difference between standard direct labor cost for actual production and…
Q: AirQual Test Corporation provides on-site air quality testing services. The company provided the…
A: BudgetThe report estimating the values for a future period from the past actual values is called a…
Q: Red River Bakery purchases land, building, and equipment for a single purchase price of $260,000.…
A: The assets can be defined as resources owned by a company, used for earning revenue for it. Assets…
Q: B55 Current Year 2025 x ✓ fx Original Year Placed in Service Useful Life Description Cost Salvage…
A: Question 1To answer this question, we need to calculate the straight-line depreciation expense and…
Q: AirQual Test Corporation provides on-site air quality testing services. The company provided the…
A: A flexible performance report is a management tool that compares actual outcomes to a plan or budget…
Q: A building acquired at the beginning of the year at a cost of $1,800,000 has an estimated residual…
A: The fixed assets tend to provide benefits for more than one year and are shown under the balance…
Q: On December 18, Intel receives $260,000 from a customer toward a cash sale of $2.6 million for…
A: The accounting equation states that the sum of liabilities and equity is equal to the assets.…
Step by step
Solved in 3 steps
- Hint(s) Check My Work Cox Electric makes electronic components and has estimated the following for a new design of one of its products: Fixed Cost $9,000 == Material cost per unit = $0.15 Labor cost per unit = $0.10 Revenue per unit = $0.65 Production Volume = 12,000 Per-unit material and labor cost together make up the variable cost per unit. Assuming that Cox Electric sells all that it produces, build a spreadsheet model that calculates the profit by subtracting the fixed cost and total variable cost from total revenue, and answer the following questions. (a) Construct a one-way data table with production volume as the column input and profit as the output. Breakeven occurs when profit goes from a negative to a positive value; that is, breakeven is when total revenue = total cost, yielding a profit of zero. Vary production volume from 5,000 to 50,000 in increments of 5,000. In which interval of production volume does breakeven occur? to units (b) Use Goal Seek to find the exact…A Company wants to introduce new product. The estimated price of each mobile phone is RO 60. The company requires a profit margin of 20% on sales. The estimated cost of manufacturing the product is : Material cost : RO 9.500 Labour Cost : RO 12.750 Other Direct Expenses : RO 7.500 Administrative Costs : RO 5.000 Marketing and Selling expenses : RO 15.000 Calculate the Target Cost of the product and the Target Cost Gap.Use the following data to solve problem #2: - Fixed costs $2,500 - Variable cost per unit $1.00 - Selling price per unit $6.00 - Run a simulation for production runs in increments of 100 (run 15) - At what production level in the company profitable - What is the amount of profit? - What is the maximum profit under these conditions - Show all work on a spreadsheet
- Eastman Publishing Company is considering publishing an electronic textbook about spreadsheet applications for business. The fixed cost of manuscript preparation, textbook design, and web-site construction is estimated to be $175,000. Variable processing costs are estimated to be $8 per book. The publisher plans to sell single-user access to the book for $54. (a) Build a spreadsheet model in Excel to calculate the profit/loss for a given demand. What profit can be anticipated with a demand of 3,300 copies? For subtractive or negative numbers use a minus sign. -23,200 (b) Use a data table to vary demand from 1,000 to 6,000 in increments of 200 to test the sensitivity of profit to demand. Breakeven occurs where profit goes from a negative to a positive value, that is, breakeven is where total revenue = total cost yielding a profit of zero. In which interval of demand does breakeven occur? (i) Breakeven appears in the interval of 3,400 to 3,600 copies. (ii) Breakeven appears in the…On-the-Go, Inc., produces two models of traveling cases for laptop computers—the Programmer and the Executive. The bags have the following characteristics. Programmer Executive Selling price per bag $ 70 $ 100 Variable cost per bag $ 30 $ 40 Expected sales (bags) per year 8,000 12,000 The total fixed costs per year for the company are $819,000. Required: a. What is the anticipated level of profits for the expected sales volumes? b. Assuming that the product mix is the same at the break-even point, compute the break-even point. c. If the product sales mix were to change to nine Programmer-style bags for each Executive-style bag, what would be the new break-even volume for On-the-Go?Eastman Publishing Company is considering publishing an electronic textbook about spreadsheet applications for business. The fixed cost of manuscript preparation, textbook design, and website construction is estimated to be $160,000. Variable processing costs are estimated to be $6.00 per book. The publisher plans to sell single-user access to the book for $46. a. Build a spreadsheet model to calculate the profit/loss for a given demand. For example, what profit can be anticipated with a demand of 3500 copies? b. Use a data table to very demand from 1000 to 6000 in increments of 200 to assess the sensitivity of profit to demand. c. Use Goal Seek to determine the access price per copy that the publisher must charge to break even with the demand of 3500 copies. Before you move on to Problem 2, make sure you save your workbook with this value displayed or else you will not receive credit.
- Cox Electric makes electronic components and has estimated the following for a new design of one of its products: Fixed Cost = $7,000 Material cost per unit = $0.15 Labor cost per unit = $0.10 Revenue per unit = $0.65 Production Volume = 12,000 Per-unit material and labor cost together make up the variable cost per unit. Assuming that Cox Electric sells all it produces, build a spreadsheet model that calculates the profit by subtracting the fixed cost and total variable cost from total revenue, and answer the following questions. (a) Construct a one-way data table with production volume as the column input and profit as the output. Breakeven occurs when profit goes from a negative to a positive value; that is, breakeven is when total revenue = total cost, yielding a profit of zero. Vary production volume from 5,000 to 50,000 in increments of 5,000. In which interval of production volume does breakeven occur? to units (b) Use Goal Seek to find the exact breakeven point. Assign Set cell:…Eastman Publishing Company is considering publishing an electronic textbook about spreadsheet applications for business. The fixed cast of manuscript preparation, textbook design, and web-site construction is estimated to be $155,000. Variable processing costs are estimated to be $6 per book. The publisher plans to sell single-user access to the book for $47. (a) Build a spreadsheet model in Excel to calculate the profit/loss for a given demand. What profit can be anticipated with a demand of 3,200 copies? For subtractive or negative numbers use a minus sign. -23800 (b) Use a data table to vary demand from 1,000 to 6,000 in increments of 200 to test the sensitivity of profit to demand. Breakeven occurs where profit goes from a negative to a positive value, that is, breakeven is where total revenue - total cost yielding a profit of zero. In which interval of demand does breakeven occur? (1) Breakeven appears in the interval of 3,200 to 3,400 copies. (1) Breakeven appears in the interval…Keleher Industries manufactures pet doors and sells them directly to the consumer via their web site. The marketing manager believes that if the company invests in new software, they will increase their sales by 10%. The new software will increase fixed costs by $400 per month. Prepare a forecasted contribution margin income statement for Keleher Industries reflecting the new software cost and associated increase in sales. The previous annual statement is as follows:
- Colin OShea has a carpentry shop that employs 4 carpenters. Colin received an order for 1,000 coffee tables. The coffee tables have a round table top and four decorative legs. An offer for $500 per table was received. Colin found an unfinished round table top that he could buy for $50 each. A. Using this quantitative cost data to make the table top, should Colin buy the table top or make it? B. What qualitative factors would be included in your decision. B. Can the vendor make it to the same quality standards? Can it be completed on time? Is there idle capacity in the factory that could be used?Sisters, Inc. manufactures professional-level printers that perform multiple features, such as high-resolution color scanning, printing, faxing, and copying. The new printer model has a target price of $600. Management requires a 20% profit on new product revenues. Required: 1. Calculate the amount of desired profit.$fill in the blank 1 2. Calculate the target cost.$fill in the blank 2A company is planning to manufacture computer desks. The fixed cost will be $60,000 and it will cost $200 to produce each desk. Each desk will be sold for $450. a. Write the cost function, C, of producing x desks. b. Write the revenue function, R, from the sale of x desks. c. Determine the break-even point. Describe what this