Business Problem Solver - Get Instant Explanations

The information listed below refers to the employees of Brennan Company for the year ended December 31, 2016. The wages are separated into the quarters in which they were paid to the individual employees. :. For 2016, State D's contribution rate for Brennan Company, based on the experience-rating system of the state, was 3.6% of the first $7,000 of each employee's earnings. The state tax returns are due one month after the end of each calendar quarter. During 2016, the company paid $3,024.00 of contributions to State D's unemployment fund. Employer's phone number: (613) 555-0029. Employer's State D reporting number: 00596. Using the forms supplied on pages 5-42 to 5-44, complete the following for 2016: a. The last payment of the year is used to pay the FUTA tax for the fourth quarter (the first three-quarter's liability was more than the $500 threshold). State D is not a credit reduction state. Tax Payment: Date _____________ Amount $____________ b. Employer's Report for Unemployment Compensation, State D-4th quarter only. Item 1 is the number of employees employed in the pay period that includes the 12th of each month in the quarter. For Brennan Company, the number of employees is ten in October, nine in November, and eight in December. All employees earned 13 credit weeks during the last quarter except for Sun (8) and Harrow (9). c. Employer's Annual Federal Unemployment (FUTA) Tax Return-Form 940 Indicate on each form the date that the form should be submitted and the amount of money that must be paid. The president of the company prepares and signs all tax forms.
Kiano, a telecommunications equipment manufacturer, manufactures PDAs (P), wireless handsets (H), and blackberrys (B). They have a limited supply of common parts---ethernet card (450 in inventory), antenna (250 in inventory), chipset (800 in inventory), battery/power supply (450 in inventory), LCD screen (600 in inventory)---that these products use. A PDA requites an ethernet card, 2 chipsets, a power supply, and 2 LCD screens. A wireless handset requires an ethernet card, an antenna, 2 chipsets, a power supply, and a LCD screen. A blackberry requires a chipset and a LCD screen. The profit on PDAs is $80, the profit on wireless handsets is $60, and the profit on blackberrys is $35. The following is a linear programming formulation of the problem.LetP = Number of PDAs producedH = Number of wireless handsets producedB = Number of blackberrys producedWe may write model for this problem as follows.Maximize 80P + 60H + 35Bsubject to:(ethernet card constraint) P + H ? 450(antenna constraint constraint) H ? 250(chipset constraint) 2P + 2H + B ? 800(power supply constraint) P + H ? 450(LCD screen constraint) 2P + H + B ? 600(non-negativity) P, H, B ? 0.Implement the above model in Solver and make sure to choose Simplex as the solving method and to choose the option "Make Unconstrained Variables non-negative"---do not explicitly put in the non-negativity constraints in the model and using the sensitivity report onlyanswer the questions below:a. Does the solution change if only 425 ethernet cards are available?b. Is it profitable to produce Blackberrys? If not, by how much should the profit margin on Blackberrys be increased to make it profitable to produce Blackberrys?c. Because of a change in production technology the profit margin on handsets has increased to $70. Should the production plan of Kiano change? What is their new profit?d. 50 chipsets were found to be defective, making the number of available chipsets 750. What will the profit be in this situation?e. Another supplier is willing to sell LCD screens to Kiano. However their prices for a LCD screen are $20 higher than what Kiano pays it's regular supplier. Should Kiano go ahead and purchase these electronic units? If yes, at most how many units should they purchase.f. Kiano is considering introducing a new product (called the Revolutionary Communicator) that combines the wireless handset and PDA. This product uses an ethernet card, an antenna, 2 chipsets, 1 power supply, and 2 LCD screens, and is expected to make a profit of $100. Should Kiano produce the Revolutionary Communicator? Why or Why not?