Please see the attachment below. Please solve this problem and show all work through excel also please provide a SOLVER ANSWER REPORT as well as the work shown on excel.

Right-lite LEDs Inc. produces a variety of portable LED lighting products. They would like to offer two new types of LED lights. a lantern and keychain ashlight, but are unsure of how many of each to manufacture. They expect to charge $3.25 per keychain ashlight and $735 per lantern ashlight. Each keychain ashlight requires 3 LED bulbs and 1 battery. Each lantern ashlight requires 6 LED bulbs and 4 batteries. Right-lite currently pays $.50 each per LED bulb and $.35 each per battery. They currently have 250 LED bulbs and 100 batteries on hand. Based on competitor's sales, they expect to be able to sell 30 lanterns and 50 keychain ashlights in the next week. Determine the number of each type of ashlight Right-lite should manufacture to maximize prots based on current constraints. Provide suggestions on how to further increase prots