6/30/2016 (in thousands)     % of % of total   Actual revenues quality costs Prevention costs           Machine maintenance $430         Supplier training 21         Design reviews 110         Total prevention costs 561 7   % 27   % Appraisal costs           Incoming inspections 111         Final testing 327         Total appraisal costs 438 5   % 21   % Internal failure costs           Rework 236         Scrap 132         Total internal failure costs 368 4   % 17   % External failure costs           Warranty repairs 168         Customer returns 570         Total external failure costs 738 9   % 35   % Total quality costs $2,105 25   %     Total revenues $8,280         12/31/2016 (in thousands)   % of % of total Actual revenues quality costs           $430         112         219         761   %   %           131         327         458   %   %           206         121         327   %   %           82         465         547   %   % $2,093   %     $9,060

Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.

345678 Sources of Sales Estimate a Sales Manager 1st Quarter $520,000 2nd Quarter 3rd Quarter 4th Quarter $410,000 $370,000 $610,000 b Marketing Consultant $540,000 $480,000 $400,000 $630,000 C Production Manager $460,000 $360,000 $350,000 $580,000 9 They have estimated that the cost of goods sold is 70 percent of sales. The company tries to maintain 10 percent of next quarter's expected cost of goods sold as the current quarter's ending inventory. The ending inventory of this year is $25,000. For budgeting, the ending inventory of the next year is expected to be $28,000. 70% 10% $25,000 $28,000 10 11 Required 12 a. Complete the spreadsheet below to allow the inventory purchases budget to be prepared for each of the estimates above. 13 14 Spreadsheet Tips 1. This spreadsheet uses a function called vertical lookup. This function can pull the appropriate values from a table. The form 15 of this function is =VLOOKUP(value,table,column#). In this example, the table is in cells A5 to F7.…

None