90.2K

Verified Solution

Link Copied!

Your Lego furniture company makes Tables and Chairs. Below, you are given the starting inventory. selling price, and Bill of Materials (recipe, or construction requirements). You are to determine the number of Tables and Chairs to be built to maximize revenue. Your answer will be the revenue generated by your production plan - rounded to the nearest whole dollar. (The number of tables and chairs may not be a whole number, which is acceptable in this chapter.) Use Scenario (sc) Scenario 1 Scenario 2 Scenario 3 Scenario 4 Scenario 5 Large wood per Table 3 5 5 2 1 3 Small wood per Table 2 1 2 3 2 Large wood per Chair 3 2 3 3 2 Small wood per Chair 4 4 4 4 3 Large wood inventory 80 90 400 95 200 Small wood inventory 80 50 50 130 190 1.241 475 688 656 503 not enough information is given to answer this question Your small toy manufacturing facility has the following information: Revenue per toy $7.95 Fixed costs $47.500 Material cost per toy $1.820 Electricity cost per toy Labor cost per toy $2.670 Profit is defined as Revenue - Total Cost Given that we will sell 24,000 toys, what must the Labor cost per toy be to generate a profit of $11,000? (Enter three decimal places in your cost) Future Value is calculated in Excel using the following function and parameters: Future Value = -FVC APR/12, 12* Years, Monthly Deposit) You expect to work for 30 years investing $120 per month. If you want to have $135,000 at the end of that time, what APR is needed? (Enter your answer with two decimal places) Your Lego furniture company makes Tables and Chairs. Below, you are given the starting inventory. selling price, and Bill of Materials (recipe, or construction requirements). You are to determine the number of Tables and Chairs to be built to maximize revenue. Your answer will be the revenue generated by your production plan - rounded to the nearest whole dollar. (The number of tables and chairs may not be a whole number, which is acceptable in this chapter.) Use Scenario (sc) Scenario 1 Scenario 2 Scenario 3 Scenario 4 Scenario 5 Large wood per Table 3 5 5 2 1 3 Small wood per Table 2 1 2 3 2 Large wood per Chair 3 2 3 3 2 Small wood per Chair 4 4 4 4 3 Large wood inventory 80 90 400 95 200 Small wood inventory 80 50 50 130 190 1.241 475 688 656 503 not enough information is given to answer this question Your small toy manufacturing facility has the following information: Revenue per toy $7.95 Fixed costs $47.500 Material cost per toy $1.820 Electricity cost per toy Labor cost per toy $2.670 Profit is defined as Revenue - Total Cost Given that we will sell 24,000 toys, what must the Labor cost per toy be to generate a profit of $11,000? (Enter three decimal places in your cost) Future Value is calculated in Excel using the following function and parameters: Future Value = -FVC APR/12, 12* Years, Monthly Deposit) You expect to work for 30 years investing $120 per month. If you want to have $135,000 at the end of that time, what APR is needed? (Enter your answer with two decimal places)

Answer & Explanation Solved by verified expert

See Answer