In this Proving Ground Assignment, you work with the sub-competency of Identifying Patterns by using the master budget unit standard dollar amounts to prepare a flexible budget. Assume that Plattsburgh Coffee's standard unit cost and master budget for 30,000 units are as follows in the first two columns. Calculate a flexible budget for 40,000 units and enter the amounts in the Flexible Budget column below. You must show your work to receive full credit (ue an Excel formula or type the numbers used to the right of the Flexible Budget column). Save the Excel workbook with your answers and upload the file. 1 Coffee bean 2 Mix-in ingredients 3 Direct labor 4 Variable manufacturing overhead 5 Fixed manufacturing overhead Standard Unit Cost $0.50 0.2 1.2 0.3 0.5 Flexible Budget (30,000 (40,000 units) Master Budget units) $15,000 6,000 36,000 9,000 15,000

In this Proving Ground Assignment, you work with the sub-competency of Identifying Patterns by using the master budget unit standard dollar amounts to prepare a flexible budget. Assume that Plattsburgh Coffee's standard unit cost and master budget for 30,000 units are as follows in the first two columns. Calculate a flexible budget for 40,000 units and enter the amounts in the Flexible Budget column below. You must show your work to receive full credit (ule an Excel formula or type the numbers used to the right of the Flexible Budget column). Save the Excel workbook with your answers and upload the file