A B D E F H 1 J K L M N 3 4 Labor Materials Overhead (30%) Profit (Goal 25%) Number of Units Produ Sold Units Unit Price Total Revenue 5 8,400.00 $10,000.00 $5,520.00 $4,600.00 100,000.00 20,000.00 $0.25 $5,000.00 8,400.00 $10,000.00 $5,520.00 $4,600.00 100,000.00 30,000.00 $0.25 $7,500.00 8,400.00 $10,000.00 $5,520.00 $4,600.00 100,000.00 90,000.00 $0.25 $22,500.00 8,400.00 $10,000.00 $5,520.00 $4,600.00 100,000.00 50,000.00 $0.25 $12,500.00 4,200.00 $10,000.00 $4,260.00 $3,550.00 100,000.00 30,000.00 $0.25 $7,500.00 4,200.00 $10,000.00 $4,260.00 $3,550.00 100,000.00 90,000.00 $0.25 $22,500.00 3,150.00 $10,000.00 $3,945.00 $3,287.50 100,000.00 90,000.00 $0.25 $22,500.00 3,150.00 $10,000.00 $3,945.00 $3,287.50 100,000.00 100,000.00 $0.25 $25,000.00 3,150.00 $10,000.00 $3,945.00 $3,287.50 100,000.00 120,000.00 $0.25 $30,000.00 3,150.00 $10,000.00 $3,945.00 $3,287.50 100,000.00 120,000.00 $0.25 $30,000.00 3,150.00 $10,000.00 $3,945.00 $3,287.50 100,000.00 120,000.00 $0.25 $30,000.00 3, $10, $3, $3, 100, 120, 6 7 8 9 $30, 10 11 12 13 13 Labor and Materials Profit Goal Overhead Target Revenue 18,400.00 $4,600.00 $5,520.00 28,520.00 -23,520.00 14 18,400.00 $4,600.00 $5,520.00 28,520.00 -21,020.00 18,400.00 $4,600.00 $5,520.00 28,520.00 -6,020.00 18,400.00 $4,600.00 $5,520.00 28,520.00 -16,020.00 14,200.00 $3,550.00 $4,260.00 22,010.00 -14,510.00 14,200.00 $3,550.00 $4,260.00 22,010.00 $490.00 13,150.00 $3,287.50 $3,945.00 20,382.50 2,117.50 13,150.00 $3,287.50 $3,945.00 20,382.50 4,617.50 13,150.00 $3,287.50 $3,945.00 20,382.50 9,617.50 13,150.00 $3,287.50 $3,945.00 20,382.50 9,617.50 13,150.00 $3,287.50 $3,945.00 20,382.50 9,617.50 $3 $3 15 20 16 g 17 18 19 17 20 Cost of Goods Total Revenue Profit Percent Profit 23,920.00 $5,000.00 -18,920.00 23,920.00 $7,500.00 -16,420.00 23,920.00 $22,500.00 -1,420.00 23,920.00 $12,500.00 -11,420.00 18,460.00 $7,500.00 -10,960.00 18,460.00 $22,500.00 4,040.00 17,095.00 $22,500.00 5,405.00 17,095.00 $25,000.00 7,905.00 17,095.00 $30,000.00 12,905.00 17,095.00 $30,000.00 12,905.00 17,095.00 $30,000.00 12,905.00 $30 21 12 22 23 Predict Future Performance WRITING TEMPLATE In 60120 words, answer this question and explain your reasoning: Based on past performance, do you expect that the company will be able to meet its goal of a profit that is equal to 25 percent of the COGS in the future? B 1 Upload a data visualization that provides the strongest evidence to support your argument. (Remember to upload your visualization as a JPG or PNG file.) Drop your file here, or browse In 15-30 words, answer these questions: What kind of graphic have you selected and why? What is the main point you would like to make with this visualization? B 1
