Answered step by step
Verified Expert Solution
Question
1 Approved Answer
ACC3040 Cost Accounting - Freedman Fabric Ventures Case It is important that you use a version of Excel that allows the use of Macros.
ACC3040 Cost Accounting - Freedman Fabric Ventures Case It is important that you use a version of Excel that allows the use of Macros. You must "Enable Macros" when you open the file or the contents of the file will not be there. Make sure you save at regular intervals and make sure you save the file when you closing it. This information sheet described the background of the case as well as guiding you through the Excel spreadsheet where all the work will be done. An empty yellow cell indicated a place where a formula needs to be entered. No hard-coded numbers should appear anywhere in the case. A hard-coded number refers to a cell containing for example "78" or "$3.56". All cells must contain a formula or a reference to another cell, for example "=A1+D4" or ="F6". Your final case attempt is due 11:30pm on the 12th February, 2021 via UM Learn. You must use the Excel given to you as each students' file is unique. Your answers will be different to every other student in the class and between sections. You will also be given the opportunity to receive feedback on your work before you submit your final case. You can submit once. You will be allowed to submit your work to date anytime between the 29th January and 5th February. Feedback will be limited to which cells are correct or incorrect. A cell whose colour is changed to blue or red signifies the correct or incorrect answer respectively. You must not resubmit this graded file. Any errors should be changed in your original file and that file should be submitted when the final case is due. The Case Freedman Fabric Ventures is a small company that produces fabric-based wardrobe accessories (such as, handbags, scarves, and headbands) and home accessories (such as placemats, pillows, and window treatments). The company keeps a limited number of popular items in stock, but primarily produces custom orders. Customers are able to choose from a wide selection of styles, sizes, and fabrics for each type of product. Most of the company's customers are small boutiques, home dcor shops, and home- decorators who serve clientele with discerning tastes. As a result, customers expect high-quality products. The sales staff of Freedman Fabric Ventures has just received the following order: See Excel file: Customer Order Form Due to its popularity, the Black and White Handbag (BW14293) is normally a stock item. However, the handbag is currently out of stock. Rather than producing only enough units to fill Kylie's order, management would like to produce a job (Job 114) that is large enough to fill Kylie's order and replenish stock. The fabric used for this job can be stacked four layers deep for cutting, while still maintaining the quality and precision of the cut. Therefore, the company is able to realize some economies of scale by
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