WF222 MBA W3 Week 3 Practice Set -HOANG KIM TO

Practice Problem 3.2ABC Company expects sales volume to be 15,000 units in the first quarter, increasing 50% in eachsucceeding quarter. Unit sales price is P55. To meet this sales requirement, the company plans tomaintain ending finished goods inventory of 20% of each quarter’s sales volume forecast, as wellas ending raw materials inventory of 10% of each quarter’s production requirements. On January1, finished goods inventory contains 1,500 units, while direct materials inventory contains 1,050units. The ratio between the final product and the raw materials is 1:3, at an anticipated cost of P3per unit of raw material. To create the product, the company expects to utilize 1 direct labor hour.It pays its laborers P5 per hour.ABC Company expects variable manufacturing overhead costs to fluctuate on the basis of directlabor hours, as follows:• Indirect materials P5• Indirect labor hours P3• Electricity P2Meanwhile, fixed manufacturing overhead costs for the year are as follows:• Rent…

Question A All That Remains Products has projected sales for next year of: Q1 Q2 Q3 Q4 Sales $ 77,300 $ 80,750 $ 87,150 $ 95,040 The company places orders each quarter that are 65 percent of the following quarter's sales and has a 60-day payables period. What is the accounts payable balance at the end of the third quarter?   Full explain this question and text typing work only     We should answer our question within 2 hours takes more time then we will reduce Rating Dont ignore this line.

2a. Using goals seek in excel, determine the total number of units Jimmy needs to sell in March in order to meet his targeted operating income for the quarter. Round your answer up to the nearest unit. 2b. if the company increases the price per unit by one dollar for March only, what is the minimum number of units that Jim needs to sell in order to meet his targeted operating income for the quarter? Round your answer up to the nearest unit. 2c. Assume that Jim met his target net operating income of $11,800 and will now receive a $1180 bonus. Jim plans to use his bonus as a down payment on a car that cost $22,600.. Using the PMT function, determine the monthly payment for his new car loan. Round your answer to two decimal places. 2d. Jim decides to wait to buy his new car until he has a larger down payment. He wants to determine what his monthly payment would be if he earned a full year of quarterly bonuses. Assuming Jim received the same quarterly bonuses for all 4/4 during the year…

The Reward One Company manufactures windows. Its manufacturing plant has the capacity to produce 12,000 windows each month. Current production and sales are 10,000 windows per month. The company normally charges $250 per window.   Requirement 1. Should Reward One accept this special​ order? Show your calculations.   Begin by completing an​ analysis, and start by showing the computation of the​ company's operating income without the special order.​ Next, calculate operating income with the special​ order, and then calculate the differences between the two columns. ​(Complete all input fields. For amounts with no​ change, make sure to enter​ "0" in the appropriate cells of the Difference​ column.) Variable costs that vary with number of units produced   Direct materials $600,000 Direct manufacturing labor 700,000 Variable costs (for setups, materials handling, quality control, and so on) that vary with number of batches, 100 batches × $1,500 per batch…

PART 4 PLEASE! The following inventory date have been established for Warriors Company: Order must be placed in multiples of 100 Annual sales are 338,000 units The purchase price per unit is P6 Carrying cost is 20% of the purchase price of the goods Fixed order costs is P48 Three days are required for delivery. What is the EOQ? How many orders should Warriors placed each year? How many units must be order every time? Calculate the total cost of ordering and carrying cost if the order quantity is 4,000 units 4,800 units 6,000 units At EOQ Thank you so much!

A company plans to sell 24,000 units of product R next year. Opening inventory of R is expected to be 2,000 units and PQ Co plans to increase inventory by 25 per cent by the end of the year. How many units of product R should be produced next year? A 23,500 units B 24,000 units C 24,500 units D 30,000 units