Module 6 Connect Problem Option 1

Kwame after his National Service and with no hope of securing a job in the formal sector has decided to run a taxi service. The following forecast has been made for the operation of a service between Abisim and Sunyani. i) Revenue totaling GH¢300 a week for 52 weeks in a year. This is net of fuel and other variable costs. ii) Tyres; four pieces for a year at GH¢120 per unit. iii) Maintenance and servicing; GH¢120 per month. iv) Salaries GH¢3,000 per year v) Insurance GH¢350 per year The net cash flow will increase at 5% per annum for the next five years due to inflation. The cost of the vehicle is estimated at GH¢28,000. The project appears quite profitable based on the NPV criteria using the Government policy rate of 26%. However the banks are offering rates far higher than the policy rate. Required: You are to calculate the break-even rate for the project.

The current data for five trees that will be analyzed in the exercise are shown in the following table Expected Yearly Demand Quantity For Sale In-Field Quantity 440 74 Trees Christmas Palm Washingtonia Gumbo Limbo Yellow Poinciana Weeping Podo 81 165 159 49 185 Trees Christmas Palm Washingtonia Std Dev 31 155 35 32 68 Gumbo Limbo Yellow Poinciana The "expected yearly demand" is an estimate of the demand over the next year for the tree. The "std dev" is the standard deviation, a measure of the error, that corresponds to the forecast. For-sale and in-field quantities are given, and finally the total number of trees planted on the farm. The demand forecast and quantities are updated on an ongoing basis as trees are sold and planted on the farm. 374 70 42 290 Your first task is to evaluate the inventory "position" of each tree. The farm does not keep any backorder information, so the only data you have is "for-sale" and "in-field" quantities. Think about "for-sale" as on-hand trees, and…

Plastomer, Inc. specializes in the manufacture of high-grade plastic film used to wrap food products. Film is rejected and scrapped for a variety of reasons (e.g., opacity, high carbon content, incorrect thickness or gauge, scratches, and so on). During the past month, management collected data on the types of rejects and the amount of scrap generated by each type. The results are given in the following table. Compute percent of total amount for each type of failure to complete the table. (Enter your responses as percents rounded to one decimal place.) Type of Failure Amount of Scrap (Ibs.) Percent of Total Amount 1 Air bubbles 500 2 Bubble breaks 26,400 3 Carbon content 250 % 4 Unevenness 3,540 5 Thickness or gauge 3,640 % 6 Орacity 650 % 7 Scratches 10,810 8 Trim 700 % 9 Wrinkles 22,810 |%

​Plastomer, Inc. specializes in the manufacture of​ high-grade plastic film used to wrap food products. Film is rejected and scrapped for a variety of reasons​ (e.g., opacity, high carbon​ content, incorrect thickness or​ gauge, scratches, and so​ on). During the past​ month, management collected data on the types of rejects and the amount of scrap generated by each type. The results are given in the following table. Compute percent of total amount for each type of failure to complete the table. ​(Enter your responses as percents rounded to one decimal​ place.)                                                  LOADING...   Type of Failure Amount of Scrap​ (lbs.) Percent of Total Amount 1 Air bubbles 500   enter your response here​%   2 Bubble breaks 25,500   enter your response here​%   3 Carbon content 250   enter your response here​%   4 Unevenness 3,680   enter your response here​%   5 Thickness or…

Article: Planning for Holiday Shipping at FedEx FedEx started as Federal Express in 1971 and made its first delivery in 1973 with 14 aircrafts and 389 employees, successfully delivering 186 packages.50 The company was founded by Frederick W. Smith who first presented his idea for the shipping company in a term paper for a business class at Yale University in 1964. Smith did not do well on the paper as his professor did not see the need for overnight package deliveries. But more than 45 years later, Smith has clearly proved his professor wrong. FedEx now employs more than 325,000 employees and uses its 652 aircraft and more than 100,000 trucks to ship on average 10.5 million packages a day in over 220 countries.   Managing such a large enterprise with so much complexity clearly requires effective planning. Similar to other shipping companies, FedEx engages in significant planning to prepare for Christmastime deliveries, the company’s peak season. FedEx typically meets with major…

OQ12

Part C

Q_1Al-Amal Factory for Plastic Production Its expected production capacity is 2300 tons, while its design capacity is 3200 tons. Calculate the effective capacity of the plant?   Q_2If the estimated quantity for four seasons is 250, using an index number 1.20, find the prediction of seasonal factors for the first semester? Q_3If the fixed costs of a company are estimated at 5000 at the selling price of 20 units, with non-cash fixed costs estimated at 2000 units and bear a variable cost per unit by 15 units, then the amount of the break-even point =?

Handerson Corporation makes a product with the following standard costs: Direct materials Direct labor Variable overhead Standard Quantity or Hours 8.5 kilos 0.4 hours 0.4 hours Standard Price or The company reported the following results concerning this product in August. Actual output Raw materials used in production Purchases of raw materials Rate $ 6.00 per kilo $ 20.00 per hour $ 6.00 per hour 3,200 units 29,030 kilos 31,600 kilos Actual direct labor-hours 1,160 hours Actual cost of raw materials purchases $ 195,920 $ 22,736 Actual variable overhead cost $ 7,540 Actual direct labor cost The company applies variable overhead on the basis of direct labor-hours. The direct materials purchases variance is computed when the materials are purchased. The materials price variance for August is: Multiple Choice $5,440 F

March demand was pridicted at 590 units of gear cycles of trevaa Itd. But the actual demand was 400 units only so fourth the company now want to forecast the april demand using exponential smoothing model with constant alpha of 0.72., calculate the same.

1. Skycell, a major European cell phone manufacturer, is making production plans for the coming year. Skycell has worked with its customers (the service providers) to come up with forecasts of monthly requirements (in thousands of phones) as shown in Table 8-10 Table 8-10 Monthly Demand for Cell Phones, in Thousands Month January February March April May June July August September October November Demand 1,000 1,100 1,000 1,200 1,500 1,600 1,600 900 1,100 800 1,400 December 1,700 Manufacturing is primarily an assembly operation, and capacity is governed by the number of people on the production line. The plant operates for 20 days a month, eight hours each day. One person can assemble a phone every 10 minutes. Workers are paid 20 euros per hour and a 50 percent premium for overtime. The plant currently employs 1,250 workers. Component costs for each cell phone total 20 euros. Given the rapid decline in component and finished-product prices, carrying inventory from one month to the next…

On Week a) Item: P24 hand 1 2 3 4 5 6 7 8 Forecast 30 30 30 40 40 40 45 45 Customer Orders 13 8 4 PAB 20 Available to Promise MPS b) Determine if each customer order will be accepted. Order Amount Week Accept (Y/N) 1 40 2 30 3 4 30 25 462M 3 Update the MPS time-phased record for accepted orders. Item: P24 Forecast Customer Orders Problem 3: The MPS planner at Murphy Motors uses MPS time-phased records for planning end-item production. The planner is currently working on a schedule for the P24, one of Murphy's top-selling motors. The planner uses a production lot size of 70 and a safety stock of 5 for the P24 motor. a) Complete the MPS time-phased record for product P24. Use the table on the left. b) Determine if Murphy Motors can accept each of the following customer orders. Update the MPS time- phased record for accepted orders. Order 1234 Amount 40 Desired Week 4 30 30 25 623 8 4 On Week hand 1 2 3 4 5 6 30 30 30 40 40 40 74 45 45 PAB 20 Available to Promise MPS On hand = 20

Exercise Torecast CIT ▷ Complete the table Month 1 2 3 4 5 6 Forecast demand 700 760 780 790 850 950 Actual demand 660 840 750 835 910 890 ▷ What is MAD? MAPE? TS? Deviation RSFE (Cumulative sum of forecast errors) MAD (Mean absolute deviation) APE (absolute % error) +

The consulting agency begins collecting data on actual population demand utilization. The first year s data is: Period March 2020 April 2020 May 2020 June 2020 Demand 31,550 40,125 38,243 35,311 32,207 32,125 35,700 40,620 n Period Demand September 41,482 2020 October 2020 November 2020 December 2020 January 2021 38,450 February 2021 33,330 38,348 34,722 36,190 July 2020 42,810 August 2020 44,230 What is the forecast demand for March 2021 considering trend and seasonality?

i need the solution for this question using excel solver ( simplex method ) send me a screenshot of the solution in excel

Merrimac Manufacturing Company has always purchased acertain component part from a supplier on the East Coast for$50 per part. The supplier is reliable and has maintained thesame price structure for years. Recently, improvements in operations and reduced product demand have cleared up somecapacity in Merrimac’s own plant for producing componentparts. The particular part in question could be produced at$40 per part, with an annual fixed investment of $25,000.Currently, Merrimac needs 300 of these parts per year.a. Should Merrimac make or buy the component part?b. As another alternative, a new supplier located nearby isoffering volume discounts for new customers of $50per part for the first 100 parts ordered and $45 per partfor each additional unit ordered. Should Merrimacmake the component in-house, buy it from the newsupplier, or stick with the old supplier?c. Would your decision change if Merrimac’s annual demand increased to 2000 parts? increased to 5000 parts?d. Develop a set of…

Hurwicz criteria

A summary of total charges from a small café's natural gas bills is provided below: Month kJ Cost October 17 November 16 December 28 36 32 January February March O a. $294 O b. $90 O c. $232 O d. $172 17 $186 187 235 265 280 207 Using regression analysis, the expected cost at 40 kJ would be