Lab - Analyze BOM costs by using the costing sheet

20 minutes

Read this first - before you start the lab!

Important

For this lab, you CAN'T sign in with your own credentials. Use the following steps to sign in to your lab environment with the correct credentials.

Ensure that you're signed in to Microsoft Learn.
Select Launch VM mode or Sign in to launch VM mode in this unit.
In the Resources tab on the lab side bar, select the T icon next to Password in the Finance and Operations box, to have the administrator password for the Virtual Machine (VM) entered for you.
Select Enter.
Microsoft Edge opens. Wait for it to navigate to the Sign in page for finance and operations. If you experience an issue with the Sign in page loading, try to restart the browser in the VM.
On the Microsoft Sign in page in finance and operations, place your mouse cursor into the Username field.
On the Resources tab of the lab side bar, below the Azure portal heading, select the T icon next to Username, then press Enter.
Your mouse cursor is now in the Password page.
On the Resources tab of the lab side bar, below the Azure portal heading, select the T icon next to select Password, then press Enter.
In the Save password window, select Never.
Select Accept in the Permissions requested page.
To see the lab instructions, select the Instructions tab on the lab side bar.

You can now begin your work on this lab.

Scenario

You want to set profit-settings to assist sales personnel in having an accurate sales price calculated after considering all costs for D0002 cabinet in the USMF company. Additionally, you need to analyze cost breakdown by viewing the costing sheet.

Calculate an accurate sales price for the D0002 cabinet

In the USMF company, go to Product information management > Products > Released products.
Use the Quick filter to filter on the Item number field with a value of D0002.
In the list, select D0002 to open the Released product details page.
Expand the Manage costs FastTab.
Select M9 under Cost groups to open the Cost groups page.
Select Edit.
Set the Profit percentage to 40.00.
Under the Profit section, select Add.
In the Profit-setting field, select Profit 1.
Set Profit percentage to 70.00.
Select Save.
Close the page.
On the Action Pane, select Engineer.
Under the BOM subsection, select BOM versions.
Under the Bill of materials lines, select M0005 to open the Product information dialog box.
Select M0005 in the Item number box to open the Released product details page.
Expand the Manage costs FastTab.
Select M2 to open the Cost groups page.
Select Edit.
Set the Profit percentage to 30.00.
Select Add.
In the Profit-setting field, select Profit 1.
Set Profit percentage to 60.00.
Select Save.
Close the page.

Review the structure of the costing sheet

Go to Cost management > Indirect cost accounting policies setup > Costing sheets.
In the tree at the left, select Root\Cost of Conversion\COC-Material\COC - M2 - Cabinets comp.
In the tree, select Root\Cost of Conversion\Overhead on Conversion\COC - OVH4 - Labor overhead\Indirect labor cost - Rate per process time.
Review the values in the Absorption basis and Rate FastTabs.
In the tree, select Root\Cost of Conversion\Overhead on Conversion\COC - OVH4 - Labor overhead.
Select OVH4 under Cost group.
Set the Profit percentage to 80.00.
Close all pages.
Go to Product information management > Products > Released products.
Use the Quick Filter to filter on the Item number field with a value of D0002.
On the Action Pane, select Manage costs.
Select Item price.
Select the Pending prices tab.
Select Calculate item cost.
In the Costing version field, enter or select 10.
Select OK.
Select View calculation details.
Select the Prices tab.
Note the Sales price per unit for the cabinet D0002, now based on the profit settings just changed.
Close all pages.

Close the lab environment