Using Excel ChM$3$ v$2\_$Instructions $-$ Protected View $$ Saved V

Search

es

Mailings

Review

View

Help

iruses. Unless you need to edit, it's safer to stay in Protected View

Enable Editing

Grader $-$ Instructions

Accounting $2019$ Project

Miller$-$Nobles $8$e$/14$e $-$ Using Excel ChM$3$ v$2$

Project Description:

Miller$-$Nobles $8$e$/14$e $-$ Using Excel ChM$3$ v$2$

Steps to Perform:

$\backslash$table$[[$Step$,$Instructions,Points Possible$],[1,\backslash$table$[[$Download and open the excel spreadsheet, Miller$-$Nobles$\_8$e$-14$eUsing$\_$Excel$\_$ChM$3\_$Start.xlsx$.$ This spreadsheet includes $2$ tabs; you will enter all answers on the second tab, ENTERANSWERS.$],[($All answers should be entered in the blue highlighted cells.$)]],],[2,\backslash$table$[[$Salish Craft Beers provides the information for the Malting Department for the month of August $2024$ presented in the Excel file.$],[$Complete a production cost report for the Malting Department for the month of August $2024$ to determine the cost of the units completed and transferred out, and the cost of the ending Work$-$in$-$Process Inventory. Assume Salish Craft Beers uses the weighted$-$average method. $(34$ pts$)],[($Always use cell references and formulas where appropriate to receive full credit. If you copy$/$paste from the Instructions tab you will be marked wrong.$)]],34],[3,\backslash$table$[[$Once completed, save the project to the desktop. File name can be anything, but DO NOT include spaces. Return to auto$-$graded excel activity window, and progress to Step $3.$ Follow on screen instructions.$],[($To review score, navigate to Results in the MyLab and click on Review link.$)]],0],[$Total Points,$34]]$

Process Costing

Using Excel to prepare a production cost report

Salish Craft Beers provides the following information for the Malting Department for the month of August $2024$:

$\backslash$table$[[,$Units,Costs$],[$Beginning Work$-$in$-$Process Inventory,$-,-],[$Started in Production in August,$26,000,54,000],[$Total to Account For,$26,000,54,000],[$Completed and Transferred to Packaging Department during August,$21,000,?],[$Ending Work$-$in$-$Process Inventory, $30\%$ complete for direct materials and $60\%$ complete for conversion costs.,$5,000,?],[$Total Accounted For,$26,000,54,000],[*$ Includes $$18,000$ direct materials and $$36,000$ conversion costs.,,$]]$

Use the blue shaded areas on the ENTERANSWERS tab for inputs.

Always use cell references and formulas where appropriate to receive full credit. If you copy$/$paste from the Instructions tab you will be marked wrong.

Requirement

Possible Points

Complete a production cost report for the Malting Department for the month of August $2024$ to determine the cost of the units completed and transferred out, and the cost of the ending Work$-$in$-$Process Inventory. Assume Salish Craft Beers uses the weighted$-$

$34$ average method.

Excel Skills

$1$ Enter numbers into cells.

$2$ Create formulas.

$3$ Format the cells requiring dollar signs.

$4$ Format the cells requiring a single underline and cells requiring double underlines.

Saving

Using Excel ChM$3$ v$2\_$Instructions $-$ Protected View $$ Saved V

Search

es

Mailings

Review

View

Help

iruses. Unless you need to edit, it's safer to stay in Protected View

Enable Editing

Grader $-$ Instructions

Accounting $2019$ Project

Miller$-$Nobles $8$e$/14$e $-$ Using Excel ChM$3$ v$2$

Project Description:

Miller$-$Nobles $8$e$/14$e $-$ Using Excel ChM$3$ v$2$

Steps to Perform:

$\backslash$table$[[$Step$,$Instructions,Points Possible$],[1,\backslash$table$[[$Download and open the excel spreadsheet, Miller$-$Nobles$\_8$e$-14$eUsing$\_$Excel$\_$ChM$3\_$Start.xlsx$.$ This spreadsheet includes $2$ tabs; you will enter all answers on the second tab, ENTERANSWERS.$],[($All answers should be entered in the blue highlighted cells.$)]],],[2,\backslash$table$[[$Salish Craft Beers provides the information for the Malting Department for the month of August $2024$ presented in the Excel file.$],[$Complete a production cost report for the Malting Department for the month of August $2024$ to determine the cost of the units completed and transferred out, and the cost of the ending Work$-$in$-$Process Inventory. Assume Salish Craft Beers uses the weighted$-$average method. $(34$ pts$)],[($Always use cell references and formulas where appropriate to receive full credit. If you copy$/$paste from the Instructions tab you will be marked wrong.$)]],34],[3,\backslash$table$[[$Once completed, save the project to the desktop. File name can be anything, but DO NOT include spaces. Return to auto$-$graded excel activity window, and progress to Step $3.$ Follow on screen instructions.$],[($To review score, navigate to Results in the MyLab and click on Review link.$)]],0],[$Total Points,$34]]$

Process Costing

Using Excel to prepare a production cost report

Salish Craft Beers provides the following information for the Malting Department for the month of August $2024$:

$\backslash$table$[[,$Units,Costs$],[$Beginning Work$-$in$-$Process Inventory,$-,-],[$Started in Production in August,$26,000,54,000],[$Total to Account For,$26,000,54,000],[$Completed and Transferred to Packaging Department during August,$21,000,?],[$Ending Work$-$in$-$Process Inventory, $30\%$ complete for direct materials and $60\%$ complete for conversion costs.,$5,000,?],[$Total Accounted For,$26,000,54,000],[*$ Includes $$18,000$ direct materials and $$36,000$ conversion costs.,,$]]$

Use the blue shaded areas on the ENTERANSWERS tab for inputs.

Always use cell references and formulas where appropriate to receive full credit. If you copy$/$paste from the Instructions tab you will be marked wrong.

Requirement

Possible Points

Complete a production cost report for the Malting Department for the month of August $2024$ to determine the cost of the units completed and transferred out, and the cost of the ending Work$-$in$-$Process Inventory. Assume Salish Craft Beers uses the weighted$-$

$34$ average method.

Excel Skills

$1$ Enter numbers into cells.

$2$ Create formulas.

$3$ Format the cells requiring dollar signs.

$4$ Format the cells requiring a single underline and cells requiring double underlines.

Saving

Using Excel ChM$3$ v$2\_$Instructions $-$ Protected View $$ Saved V

Search

es

Mailings

Review

View

Help

iruses. Unless you need to edit, it's safer to stay in Protected View

Enable Editing

Grader $-$ Instructions

Accounting $2019$ Project

Miller$-$Nobles $8$e$/14$e $-$ Using Excel ChM$3$ v$2$

Project Description:

Miller$-$Nobles $8$e$/14$e $-$ Using Excel ChM$3$ v$2$

Steps to Perform:

$\backslash$table$[[$Step$,$Instructions,Points Possible$],[1,\backslash$table$[[$Download and open the excel spreadsheet, Miller$-$Nobles$\_8$e$-14$eUsing$\_$Excel$\_$ChM$3\_$Start.xlsx$.$ This spreadsheet includes $2$ tabs; you will enter all answers on the second tab, ENTERANSWERS.$],[($All answers should be entered in the blue highlighted cells.$)]],],[2,\backslash$table$[[$Salish Craft Beers provides the information for the Malting Department for the month of August $2024$ presented in the Excel file.$],[$Complete a production cost report for the Malting Department for the month of August $2024$ to determine the cost of the units completed and transferred out, and the cost of the ending Work$-$in$-$Process Inventory. Assume Salish Craft Beers uses the weighted$-$average method. $(34$ pts$)],[($Always use cell references and formulas where appropriate to receive full credit. If you copy$/$paste from the Instructions tab you will be marked wrong.$)]],34],[3,\backslash$table$[[$Once completed, save the project to the desktop. File name can be anything, but DO NOT include spaces. Return to auto$-$graded excel activity window, and progress to Step $3.$ Follow on screen instructions.$],[($To review score, navigate to Results in the MyLab and click on Review link.$)]],0],[$Total Points,$34]]$

Process Costing

Using Excel to prepare a production cost report

Salish Craft Beers provides the following information for the Malting Department for the month of August $2024$:

$\backslash$table$[[,$Units,Costs$],[$Beginning Work$-$in$-$Process Inventory,$-,-],[$Started in Production in August,$26,000,54,000],[$Total to Account For,$26,000,54,000],[$Completed and Transferred to Packaging Department during August,$21,000,?],[$Ending Work$-$in$-$Process Inventory, $30\%$ complete for direct materials and $60\%$ complete for conversion costs.,$5,000,?],[$Total Accounted For,$26,000,54,000],[*$ Includes $$18,000$ direct materials and $$36,000$ conversion costs.,,$]]$

Use the blue shaded areas on the ENTERANSWERS tab for inputs.

Always use cell references and formulas where appropriate to receive full credit. If you copy$/$paste from the Instructions tab you will be marked wrong.

Requirement

Possible Points

Complete a production cost report for the Malting Department for the month of August $2024$ to determine the cost of the units completed and transferred out, and the cost of the ending Work$-$in$-$Process Inventory. Assume Salish Craft Beers uses the weighted$-$

$34$ average method.

Excel Skills

$1$ Enter numbers into cells.

$2$ Create formulas.

$3$ Format the cells requiring dollar signs.

$4$ Format the cells requiring a single underline and cells requiring double underlines.

Saving

Using Excel ChM$3$ v$2\_$Instructions $-$ Protected View $$ Saved V

Search

es

Mailings

Review

View

Help

iruses. Unless you need to edit, it's safer to stay in Protected View

Enable Editing

Grader $-$ Instructions

Accounting $2019$ Project

Miller$-$Nobles $8$e$/14$e $-$ Using Excel ChM$3$ v$2$

Project Description:

Miller$-$Nobles $8$e$/14$e $-$ Using Excel ChM$3$ v$2$

Steps to Perform:

$\backslash$table$[[$Step$,$Instructions,Points Possible$],[1,\backslash$table$[[$Download and open the excel spreadsheet, Miller$-$Nobles$\_8$e$-14$eUsing$\_$Excel$\_$ChM$3\_$Start.xlsx$.$ This spreadsheet includes $2$ tabs; you will enter all answers on the second tab, ENTERANSWERS.$],[($All answers should be entered in the blue highlighted cells.$)]],],[2,\backslash$table$[[$Salish Craft Beers provides the information for the Malting Department for the month of August $2024$ presented in the Excel file.$],[$Complete a production cost report for the Malting Department for the month of August $2024$ to determine the cost of the units completed and transferred out, and the cost of the ending Work$-$in$-$Process Inventory. Assume Salish Craft Beers uses the weighted$-$average method. $(34$ pts$)],[($Always use cell references and formulas where appropriate to receive full credit. If you copy$/$paste from the Instructions tab you will be marked wrong.$)]],34],[3,\backslash$table$[[$Once completed, save the project to the desktop. File name can be anything, but DO NOT include spaces. Return to auto$-$graded excel activity window, and progress to Step $3.$ Follow on screen instructions.$],[($To review score, navigate to Results in the MyLab and click on Review link.$)]],0],[$Total Points,$34]]$

Process Costing

Using Excel to prepare a production cost report

Salish Craft Beers provides the following information for the Malting Department for the month of August $2024$:

$\backslash$table$[[,$Units,Costs$],[$Beginning Work$-$in$-$Process Inventory,$-,-],[$Started in Production in August,$26,000,54,000],[$Total to Account For,$26,000,54,000],[$Completed and Transferred to Packaging Department during August,$21,000,?],[$Ending Work$-$in$-$Process Inventory, $30\%$ complete for direct materials and $60\%$ complete for conversion costs.,$5,000,?],[$Total Accounted For,