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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started