Project 2: Job cost analysis for Bexia Fortunia, Inc - Excel Download Excel Data Download Download Excel
Question:
Project 2: Job cost analysis for Bexia Fortunia, Inc - Excel Download Excel Data Download Download Excel Data Overview Bexia Fortunia, Inc. manufactures a variety of custom cabinets. It has several manufacturing facilities located in six different states or provinces: Quebec and Ontario in Canada, and Oregon, Missouri, Georgia, and New Mexico in the United States. Each manufacturing facility makes its own unique products. The company uses just-in-time inventory management, so it has no significant inventory. Bexia Fortunia has five sales representatives who can sell products from any of its manufacturing facilities. All transactions in Bexia Fortunia's job cost system for the most recent month have been exported to an Excel file that can be downloaded on Canvas. In this transaction file, revenue amounts are shown as positive numbers while all costs shown as negative numbers. The transactions file contains the following fields: Job # Customer # Customer name Sales rep Facility Country General ledger account Amount Job costs in Bexia Fortunia's system are tracked using four different general ledger numbers: G/L #3100 - Revenue; G/L #4101 - Direct material; G/L #4301 - Direct labor; and G/L #4501 - Manufacturing overhead. For this case, you will need to know how