FNSACC412_TL_SW_Appx_Activity 3 Purchase Budget

Q4) A manufacturer provides specialized microchips. During the next 3 months its sales, costs, and available time are shown in the table. Month 1 Month 2 Month 3 There are no chips in stock at the beginning of the first month. It takes 1.5 hr of production time to produce a chip and costs $5 to store a chip from one month to the next. Determine a production schedule that meets the demand requirements, does not exceed the monthly production time limitations, and minimizes cost. Note that no chips should be in stock at the end of the 3 months. Use fmincon. Chips required Cost regular time ($/chip) Cost overtime ($/chip) Regular operation time (hr) Overtime (hr) 1000 100 110 2500 100 120 2200 120 130 2400 2400 720 2400 720 720

|Product D is stocked only at the AMC Chemical Company's Dallas warehouse and at the company's plant warehouse in Akron. The sales director has forecast product sales from the Dallas warehouse to be 40 units per week for the next 8 weeks. Product D is manufactured at the firm's Akron plant using 2 units of ingredient X per unit of product D. Information: Ingredient X Projected available balance: 4 Units Schedule receipt in week 1: 320 units Safety stock quantity: 2 Product D in Dallas Product D in Plant Warehouse Warehouse Projected available balance: 85 Units Safety stock quantity: 5 units Lead time: 2 weeks Lot for lot size quantity Projected available balance: 2 Units Schedule receipt in week 1: 46 units Safety stock quantity: 8 units units Lead time: 1 week Lead time: 4 weeks Lot for lot size quantity Lot size quantity: 320 units Prepare the DRP records for product D at the Dallas warehouse and the plant warehouse as well as the MRP record for ingredient X (Assume ingredient X is…

Calculate customer life time value for the data below. (Show Work) Purchase Occasion Transition Probability Average Basket Size 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 ΝΑ 55% 75% 78% 83% 81% 81% 86% 82% 85% 90% 93% 85% 89% 85% 91% 97% 97% 96% 85% 83% 89% 82% 79% 82% 89% 88% 86% 67% 75% $46.71 $56.71 $57.93 $56.87 $58.26 $66.90 $63.62 $70.27 $63.03 $62.60 $71.81 $76.76 $78.14 $65.65 $74.84 $81.11 $72.08 $87.30 $71.94 $75.44 $70.35 $72.86 $66.68 $79.90 $93.91 $61.08 $94.16 $100.40 $77.89 $99.70

Consider the following price and dividend data for Ford Motor Company: Dividend ($) Date December 31, 2004 January 26, 2005 April 28, 2005 July 29, 2005 October 28, 2005 December 30, 2005 Price ($) $14.04 $13.43 $9.14 OA. -44.4% OB. -40.2% OC.-42.32% OD. -38.1% $10.74 $8.02 $7.72 $0.12 $0.12 $0.12 $0.12 Assume that you purchased Ford Motor Company stock at the closing price on December 31, 2004 and sold it at the closing price on December 30, 2005. Your realized annual return is for the year 2005 is closest to:

Q3: FIND INITIAL FEASIRLE SOLUTION COST FOR GIVEN PROBLEM by using A north-west oomer rule Bleast cost method e-Vogels approvimation method D1 D2 D3 D4 SUPPLE P1 2. 11 P2 1. 1. Pa 8. 15 6. 10 Demand 2. A* JIS O 11600 O 11300 O 11200 O 11000

29 00:24 1 令.l 50 B/s Question no. 02: A Leading manufacturer of Action Figures is about to introduce four new Action Figures. The accompanying table summarizes price and cost data, combined fixed costs equal $650,000. A marketing research study predicts that for each unit sold of Noyan, 2 units of Dogan, 3 units of Bamsi and 4 units of Turgut will be sold. Action Figures Turgut Bamsi Dogan Novan Selling Price (in dollars) 35 26 24 16 Variable Cost/unit (in dollars) 17 12 12 11 Table 1 a) How many product mix units must be sold to break even? b) How does it translate into sales of individual games?

11.May I know the correct option?

Consider the data below: Month Demand Jan 164 Feb 224 Mar 209 269 Apr May 119 Jun 194 Jul 179 Aug 134 Sep 164 Oct 149 Nov 269

Question 1: The MTM manufacturing company disclose the following information of their inventories, for Mar, 2020.                                                                                                 The data related to the beginning Raw material inventory and purchases of raw material inventory are as follow: Date Particulars Units Rate(Rs) Mar 01 Inventory (beginning ) 3685 17 08 Purchases 4600 19 14 Purchases 3100 22 22 Purchases 2300 19 27 Purchases 3000 21 During the month of January raw material were used for production was worth Rs. 243645. FOH was ¾ of Direct Material, and Direct labor cost Rs. 1,80,000. There is no Beginning inventory of Work in Process and Finished good, while Ending inventory worth Rs. 30000 of finished goods and 25% is still work in process. Required:  A. Cost of Goods Statement for each case. LIFO Method Weighted Average Method

Franklin Tooling, Inc., manufactures specialty tooling for firms in the paper-making industry. All of their products are engineer-to-order and so the company never knows exactly what components to purchase for a tool until a customer places an order. However, the company believes that weekly demand for a few components is fairly stable. Component 135.AG is one such item. The last 26 weeks of historical use of component 135.AG is recorded below. Week Demand Week Demand 1 2 3 4 5 6 7 8 9 10 11 12 13 137 136 143 136 141 128 149 136 134 142 125 134 118 14 15 16 17 18 19 20 21 22 23 24 25 26 131 132 124 121 127 118 120 115 106 120 113 121 119 Use OM Explorer’s Time Series Forecasting Solver to evaluate the following forecasting methods. Start error measurement in the fifth week, so all methods are evaluated over the same time interval. Use the default settings for initial forecasts.i. Naïve (1-Period Moving Average)ii. 3-Period Moving Averageiii. Exponential Smoothing,…

Table 1. Demand of Hairdryer from January to July [Jadual 1. Permintaan Pengering Rambut dari Januari 2021 hingga Julai 2021] Month Demand January February 2800 2870 March 2968 April Мay 3000 3100 Jun 3150 July 3400 a) Calculate forecast future demand for May, June, July and August by using 3 months simple moving average.[hitung ramalan permintaan masa depan untuk bulan Mei, Jun, Julai dan Ogos dengan menggunakan purata bergerak sederhana 3 bulan.] *

a. Meaning of ABC analysis?

Problem 2: Week Forecast Customer Orders Projected On-Hand Inventory MPS Available-to-Promise On-hand Inventory schedule production whenever projected on-hand inventory drops below MPS lot size Complete the master production schedule based on the following information 160 160 30 300 1 120 110 2 100 100 3 130 75 4 110 50 5 140 32 6 140 11 7 170 5 8 180 0

Define INVENTORY CONTROL?

Demand for stereo headphones and MP3 players for joggers has caused Nina Industries to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demand for the players for last year was as follows:   MONTH DEMAND (UNITS) January 4,240 February 4,340 March 4,040 April 4,440 May 5,040 June 4,740 July 5,340 August 4,940 September 5,440 October 5,740 November 6,335 December 6,030     a. Using linear regression analysis, what would you estimate demand to be for each month next year? (Do not round intermediate calculations. Round your answers to 2 decimal places.)     b. To be reasonably confident of meeting demand, Nina decides to use 4 standard errors of estimate for safety. How many additional units should be held to meet this level of confidence? (Do not round intermediate calculations. Round…

Question 23  Company A carries 5,000 items. Customers ordered 1,000 items from inventory last week. Company A was able to fulfill 600 items of the order. What is the stock out probability for last week? Group of answer choices 0.08 0.4 0.6 0.92

The units of Manganese Plus available for sale during the year were as follows: Mar. 1 June 16 Nov. 28 Inventory Purchase Purchase 23 units @ $29 32 units @ $30 42 units @ $36 97 units $667 960 1,512 $3,139 There are 14 units of the product in the physical inventory at November 30. The periodic inventory system is used. a. Determine the inventory cost by the FIFO method. $ b. Determine the inventory cost by the LIFO method. $ c. Determine the inventory cost by the weighted average cost methods. Round intermediate calculations and final answer to two decimal places.

If sale is 78 during March, 85 in April, 90 in May, 84 in June, and 97 in July, what, is the three-month simple moving average for August? a. 88.667 Ob. 90.333 O c. 97 O d. 86.8

H4. Please show all step by step calculation

Beginning inventory and purchases Units Unit Cost Total Cost Jan 1 60 $7 $420 April 1 45 $10 $450 July 1 70 $8 $560 September 1 40 $6.50 $260   If ending inventory is 105 units, what is the weighted average of each unit in inventory?

Problem 3-14 (Algo) Demand for stereo headphones and music players for joggers has caused Nina Industries to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demand for the players for this year was as follows: MONTH DEMAND (UNITS) 4,150 4,25e 3,950 4, 350 4,95e 4,650 5,25e 4,850 5,35e 5,65e 6,25e 5,95e January February March Аpril Мay June July August September October November December a. Using linear regression analysis, what would you estimate demand to be for each month next year? Using a spreadsheet, follow the general format in Exhibit 3.8. (Do not round Intermedlate calculatlons. Round your answers to 2 decimal places.) Month Forecast January February March April May June July August September October November December b. To be reasonably confident of meeting demand, Nina decides to use 3 standard errors…

Questions 2 – Capital budgeting and NPV Responsible Testing Company may buy DNA‐testing equipment A costing $60,000 now (at year 0). This  equipment  is  expected  to  reduce  labor  costs  of  the  clinical  staff,  net  of  all  staff  training expenditures, by $20,000 annually in the subsequent years following the investment. Equipment A has a useful life of 8 years and can be straight‐line‐depreciated over its years of operations. No salvage value is expected at the end. The corporate tax rate (combined federal and state) is 40% and the company’s required rate‐of‐return is 15%.   (2a) Describe the company’s “investment project”. Calculate the relevant cash flows and use the NPV method to determine the attractiveness of this project. (2b) Suppose that in the second year (year 2) a more efficient and effective DNA‐testing equipment B is expected to enter the market. The new equipment costs $90,000, will have an effective operating life of 6 years, can be straight‐line‐depreciated but…