A carton manufacturer produces two sizes of carton for a fortune 100 logistics company. The logistics company has agreed to buy the cartons for next 12 months. The carton manufacturer now has tasked their operations manager to identify the number of cartons to produce for each size to achieve maximum revenue. When sold to the logistics company, carton A5 sells for 6 dollars a piece and carton C5 sells for 8 dollars a piece. The carton manufacturer has a labor hours capacity of 8,300 hours and budget for raw material limited to $ 185,580. Carton A5 utilizes 0.09 hours of labor and $2 of material cost per piece whereas, carton C5 utilizes 0.12 hours of labor and $2.75 of material cost per piece. Formulate a LP model and solve in excel solver to calculate the optimal quantities of each type leading to maximizing the revenue and satisfying all constraints.
Q: F2
A: To find the IRR, you can use an iterative method, a financial calculator, or software that can solve…
Q: You own 170 shares of stock in Halestorm, Incorporated, that currently sells for $82.30 per share.…
A: When a company announces a dividend, the stock price theoretically decreases by the amount of the…
Q: is there an ethical issue that must be considered between the financial advisor and the client in…
A: Yes, ethical questions that are related to a financial advisor and his client with respect to…
Q: Muscle Car Payment Ord You want to buy a new sports car from Muscle Motors for $69,800. The contract…
A: If you have any problem let me know here in comment box for this thankyou.
Q: Use the following information for the next two questions. Firms X and Y have the following borrowing…
A: Calculate the floating-rate borrowing cost for Company X:Company X's floating-rate borrowing cost is…
Q: Please show step by step and formulas to solve and answer A. and B. You borrow a Graduated Payment…
A: A. The monthly payment for the first 5 years:Given that the loan amount is $400,000 and the lender…
Q: Cirice Corp. is considering opening a branch in another state. The operating cash flow will be…
A: In the above answer, the IRR calculation involves analyzing the net present value (NPV) of all…
Q: Please show how to solve this using excel and please show all formulas to answer questions A. B. and…
A: To solve these problems in Excel, you can use various financial functions and formulas. Here's how…
Q: OmegaTech is considering project A. The project would require an initial investment of $52,100.00,…
A: The NPV (Net Present Value) of Project A for OmegaTech is greater than -$11.16 but less than…
Q: Use simple decision trees and a 10% per year discount rate to evaluate a project, which has two…
A: Approach to solving the question:Construct a decision tree representing the different phases of the…
Q: Fill in the yellow cells using excel funtions (trying to build excel model please use excel…
A: In mutually exclusive projects, if NPV and IRR are conflicting, then we should go with NPV because…
Q: You are looking to purchase a Tesla Model X sport utility vehicle. The price of the vehicle is…
A: To find the amount of the balloon payment six years from now, we'll first calculate the loan amount…
Q: Solve it using formulas, no tables
A: The company has two choices:Option 1: Steady Interest Rate (4.5% over 15 years)Imagine putting away…
Q: Derek will deposit $4,619.81 per year for 13.77 years into an account that earns 14.27%, The first…
A: The objective of the question is to find out the total amount in the account 43.96 years from today,…
Q: What are some hurdles of the Affordable Care Act (ACA)?
A: The Affordable Care Act (ACA), also known as Obamacare, was enacted in 2010 with the aim of…
Q: Accounting
A: GENERAL NOTE: If you use the word "Less" in the financial statements, you would not need to use the…
Q: provide answer
A: Given information: Monthly Payments (PMT) = $251.06 As the compounding and frequency of payment is…
Q: From November to December of 2015, the price per share of BP Oil dropped from $95.75 to $76.75.…
A: If you have any problem let me know here in comment box for this thankyou for your question.
Q: None
A: A hockey stick forecast is a term used in business and financial planning to describe a projected…
Q: Alla Bazzter Excursions Co. holds a total in assets of $840,000 but $168,000 of that is excess cash.…
A: Step 1: Calculate the current EPS before the stock buyback.Current EPS = Net Income / Total Shares…
Q: A company is considering two mutually exclusive expansion plans. Plan A requires a $40 million…
A: Please refer to this info for Project A.the initial outlay -$40M; cash flows $6.39M for 20 years; PV…
Q: A corporate bond matures in 2 years, pays semi-annual coupons, has a coupon rate of 5.8% and a AA…
A:
Q: Marie Corp. has $1,860 in debt outstanding and $2,853 in common stock (and no preferred stock). Its…
A: The objective of the question is to calculate the Weighted Average Cost of Capital (WACC) for Marie…
Q: The following is cash flow data for Rocket Transport: Cash dividend Purchase of bus Interest paid on…
A: A) Net cash provided by or used in investing activities Investing activities typically include cash…
Q: #1 Caspian Sea Drinks is considering the purchase of a plum juicer - the PJX5. There is no planned…
A: Given information:a. Initial Cost of PJX5 = $2.45 millionb. Depreciated Book Value in Year 10 =…
Q: When individuals want to buy more stock, ______ (demand or supply) _____(increases or decreases) and…
A: Ans. When individuals want to buy more stock, demand increases and the price of the stock increases.…
Q: Coore Manufacturing has the following two possible projects. The required return is 13 percent. Year…
A: Let's calculate the profitability index and NPV for each project and then determine which project,…
Q: Analytical VaR Use the table below at the given level of accuracy: Critical values for VaR…
A: Step 1: Understanding the definitionsThe Value at Risk (VaR) indicates the maximum loss expected…
Q: The following information is available about an investment opportunity: Initial Capital…
A: Step 1: Initial Investment and Changes in Net Working CapitalInitial Capital Expenditure: This…
Q: Ninecent Corporation has a target capital structure of 60 percent common stock, 5 percent preferred…
A: To calculate the Weighted Average Cost of Capital (WACC) for Ninecent Corporation, we'll follow…
Q: Parents wish to have $80,000 available for a child's education. If the child is now 8 years old, how…
A: Refer to the attached image for the detailed solution:
Q: The IRR of normal Project X is greater than the IRR of normal Project Y, and both IRRS are greater…
A: Here's why:IRR: Both project IRRs are greater than zero, indicating they are expected to create…
Q: Question 18 1 pts You have seven old machines in your shoe factory. They require much maintenance to…
A: Question 18. Net Present Value is the difference between the present value of cash flows and the…
Q: D Question 8 What is the IRR of Project B if the outlay is $13,000 and the after-tax cash inflows…
A: Given information: Initial investment (CF0) = $13,000 Cashflow in year 1 (CF1) = $4,700 Cashflow in…
Q: Am. 131.
A: Question: Calculating the Lease Value:a. Marginal Tax Rate of T = 0.307: Step 1: Calculate present…
Q: Vital Silence, Inc., has a project with the following cash flows: Year Cash Flow 0 $27,300 11,300 2…
A: Given information: Initial investment (CF0) = -$27,300 Cashflow in year 1 (CF1) = $11,300 Cashflow…
Q: A 1000 - par value 25-year bond with 4% semiannual coupons is callable on any coupon date in the…
A: 1. Calculating Maximum Purchase Price:. We have a bond with a face value (FV) of $1000, a coupon…
Q: Calculate the accumulation at the end of 20 years of an investment of £550 made at time t = 0, if…
A: (i) 8% per annum nominal interest rate convertible monthly for the first 15 years, and thereafter 7%…
Q: Badger Corp. has an issue of 6% bonds outstanding with 6 months left to maturity. The bonds are…
A: Step 1: Calculate the after-tax cost of debt.Cost of debt = Annual interest payment / Current market…
Q: (Corporate income tax) Sales for J. P. Hulett Inc. during the past year amounted to $4.2 million.…
A: To compute J.P. Hulett Inc.'s tax liability and average and marginal tax rates, I will need to…
Q: Nyam-BiscoCookie Company wants to introduce a new product, Rolling In Dough Pies. The initial…
A: The objective of the question is to calculate the Internal Rate of Return (IRR) for the new product,…
Q: Suppose that LilyMac Photography has annual sales of $233,000, cost of goods sold of $168,000,…
A: To find LilyMac Photography's cash cycle and operating cycle, we'll use the following formulas:1.…
Q: The table shows the specifications of an adjustable rate mortgage (ARM). Assume no caps apply. Find…
A: Step 1: Identify the loan terms.The loan amount or principal is $88,314.The loan term is 60 months,…
Q: please give me answer in this blank table
A: Approach to solving the question: For better clarity of the solution, I have attached the Excel…
Q: ! Required information [The following information applies to the questions displayed below] Golf…
A: The objective of the question is to record the transactions that affect the stockholders' equity of…
Q: RiverRocks (whose WACC is 12.3%) is considering an acquisition of Raft Adventures (whose WACC is…
A: Step 1: Identify the relevant cash flows and growth rate.The acquisition of Raft Adventures is…
Q: Cosplay Unlimited sells 700 outfits per year at an average price of $165. The terms of the sale are…
A: Step 1: Calculation of the company's accounts receivable balance. AmountWorking (Sales revenue*…
Q: 1) You are a big fan of investing in IPOs and three new IPOs are expected to hit the market this…
A: Part 2: Explanation:1. To find the average underpricing of the three IPOs, we first calculate the…
Q: cost at t = 2. Nebraska Inc is considering a project that has an upfront 0 of $1,500,000. The…
A: The objective of the question is to calculate the difference in the Net Present Value (NPV) of the…
Q: 50% 4 Normal text Lato - + 22 12 B IUA Q1) What is the IRR of Project B if the outlay is $13,000 and…
A: the internal rate of return of project b,
Step by step
Solved in 2 steps
- Crane, Inc., sells two types of water pitchers, plastic and glass. Plastic pitchers cost the company $30 and are sold for $40. Glass pitchers cost $26 and are sold for $47. All other costs are fixed at $280,800 per year. Current sales plans call for 14,000 plastic pitchers and 28,000 glass pitchers to be sold in the coming year. Crane, Inc., has just received a sales catalog from a new supplier that is offering plastic pitchers for $28. What would be the new contribution margin per unit if managers switched to the new supplier? What would be the new breakeven point if managers switched to the new supplier? (Use contribution margin per unit to calculate breakeven units. Round answers to 0 decimal places, e.g. 25,000.)A hardware store sells paint that has a demand of 9,706 gallons per year. The store purchases the paint from a supplier for 11.2 dollars per gallon The unit holding cost per year is 24 percent of the unit purchase cost. while the ordering cost is 175 dollars per order. The paint supplier has a lead time of 10 days. What is the annual ordering cost if the store uses the order quantity of 2,103 gallons per order? Assume EOQ model is appropriate. Use at least 4 decimal places.Jansen Crafters has the capacity to produce 50,000 oak shelves per year and is currently selling 44,000 shelves for $32 each. Curate Furniture approached Jansen about buying 1,200 shelves for bookshelves it is building and is willing to pay $26 for each shelf. No packaging will be required for the bulk order. Jansen usually packages shelves for Home Depot at a price of $1.50 per shelf. The $1.50 per shelf cost is included in the unit variable cost of $27, with annual fixed costs of $320,000. However, the $1.50 packaging cost will not apply in this case. The fixed costs will be unaffected by the special order and the company has the capacity to accept the order. Based on this information, what would be the profit if Jensen accepts the special order?
- A sport store carries a shoe for men that sells an approximately 3,049 pairs per year. The store purchases the shoes from the manufacturer for $30.2 per pair. The order lead time is 12 days. It costs the store $58 to place and process an order. The annual carrying charge is 24 percent. Assume EOQ model is appropriate and 360 days a year. If the store uses an order quantity of 276 units per order, what is the annual ordering cost? Use at least 4 decimal places.An auto parts supplier sells Hardy-brand batteries to car dealers and auto mechanics. The annual demand is approximately 1,200 batteries. The supplier pays $28 for each battery and estimates that the annual holding cost is 30 percent of the battery’s value. It costs approximately $20 to place an order (managerial and clerical costs). The supplier currently orders 100 batteries per month. What is the economic order quantity? Based on your answer above, how many orders will be placed per year using the EOQ? Determine the ordering, handling, and total inventory costs for the EOQ. Determine the effective annualized cost of financing for the following credit terms, assuming that (1) discounts are not taken, (2) accounts are paid at the end of the credit period, and (3) use 365=day year: a. 1/10, n/30; b. 3/10, n/30; c. 3/10, n/60; d. 2/10, n/90Jansen Crafters has the capacity to produce 50,000 oak shelves per year and is currently selling 44,000 shelves for $32 each. Cutrate Furniture approached Jansen about buying 1,200 shelves for bookcases it is building and is willing to pay $26 for each shelf. No packaging will be required for the bulk order. Jansen usually packages shelves for Home Depot at a price of $1.50 per shelf. The $1.50 per-shelf cost is included in the unit variable cost of $27, with annual fixed costs of $320,000. However, the $1.50 packaging cost will not apply in this case. The fixed costs will be unaffected by the special order and the company has the capacity to accept the order. Based on this information, what would be the profit if Jansen accepts the special order?A. Profits will decrease by $1,200.B. Profits will increase by $31,200.C. Profits will increase by $600.D. Profits will increase by $7,200.
- Sunland, Inc., sells two types of water pitchers, plastic and glass. Plastic pitchers cost the company $25 and are sold for $35. Glass pitchers cost $24 and are sold for $45. All other costs are fixed at $572,000 per year. Current sales plans call for 14,000 plastic pitchers and 28,000 glass pitchers to be sold in the coming year.Crane, Inc., sells two types of water pitchers, plastic and glass. Plastic pitchers cost the company $30 and are sold for $40. Glass pitchers cost $26 and are sold for $47. All other costs are fixed at $280,800 per year. Current sales plans call for 14,000 plastic pitchers and 28,000 glass pitchers to be sold in the coming year. How many pitchers of each type must be sold to break even in the coming year? (Use contribution margin per unit to calculate breakeven units.)A microbrewery purchases malt for production. The supplier charges $35 for delivery (no matter how much is delivered) and $1.20 per gallon. The annual holding cost is 35% of the price per gallon. Usage is 250 gallons/week. a) If the order quantity is 1000 gallons, what is the average inventory? b) If the order quantity is 1500 gallons, how many orders are placed each year? c) What is the EOQ quantity? d) If the order quantity is 2500 gallons, what is the sum of the ordering and holding costs PER GALLON? e) If orders are for the EOQ amount, what is the annual cost of the inventory system as a percentage of the annual purchase cost? f)If orders must be in integer multiples of 1000 gallons, how much should be ordered to minimize ordering and holding costs PER GALLON? g) A 3% purchase price discount is given if orders are for 8000 gallons or more. What would total annual costs (purchasing, ordering, and holding) be using this discount?
- Rapido Quadcopters plans to sella standard quadoopter (toy drone) for $54 and a delue quadcopter for $74. Rapido purchases the standard quadcopter for $44 and the deluse quadcopter for $54. Management expects to sel wo dekove quadcopters for every three standard quadcopters The company's monthly foxed expenses are $11,200. How many of each type of quadcopter must Rapido sell monthly to breakeven? To eam $7,7007 First identity the formula to compute the sales in units at various levels of operating income using the contribubon margin approach (Abbreviations used Avg. average, and CM e contribution margin) Fied expenses Operating income Weighed-avg CM per unit Breakeven sales in units Next compute the weighted average contribution margin per unit. First identity the formula labols, then complete the calculations step by step Standard Sale price per unt Deduct Varable expense per unit Contribution margin per unit Sales mix in unts Contribution margin Weighted average contribution margin…One of the bulk raw beverages, which Blanchard buys, is gin. Assume that the cost of purchasing enough raw gin for one case is $100. Each time they place an order their cost for processing the order is $20. The annual holding cost is 33% of item cost and demand for gin is 2500 cases per year. Calculate the EOQ for this product. If the lead-time is one day, what is the reorder point ROP? What is the annual total cost of this strategy? What is the average inventory? What is the inventory turnover? Please do fast ASAP fast3. PHL assembles security monitors. It purchases 900 black-and-white cathode ray tubes per month at $80 each. Ordering costs are $120, and annual carrying costs are $20 per unit. - a) Determine the economic order quantity (2 points) - b) Find number of orders per year (1 point) - c) If the supplier offer a price of $79.5 per tube for ordering 1200 tubes in a lot, would you evaluate and advise PHL to take advantage of the offer? (2 points)