The New Orleans Shirt Company makes two types of T-shirts: basic and custom. (Click the icon to view the additional information.) For the same time period, the New Orleans Shirt Company compiled the following data for the Custom Design Department: (Click the icon to view the Custom Design data.) For March 2018, the New Orleans Shirt Company compiled the following data for the Cutting and Sewing Departments: E (Click the icon to view the Cutting data.) Read the requirements. (Click the icon to view the Sewing data.) A More Info - X Basic shirts are plain shirts without any screen printing on them. Custom shirts are created using the basic shirts and then adding a custom screen printing design. The company buys cloth in various colors and then makes the basic shirts in two departments, Cutting and Sewing. The company uses a process costing system (weighted average method) to determine the production cost of the basic shirts. In the Cutting Department, direct materials (cloth) are added at the beginning of the process and conversion costs are added evenly through the process. In the Sewing Department, no direct materials are added. The only additional material, thread, is considered an indirect material because it cannot be easily traced to the finished product. Conversion costs are added evenly throughout the process in the Sewing Department. The finished basic shirts are sold to retail stores or are sent to the Custom Design Department for custom screen printing. The Custom Design Department creates custom shirts by adding screen printing to the basic shirt. The department creates a desian based on the customer's re then prints the design using up to four colors. Because these shirts have the custom printing added, which is unique for each order, the additional cost incurred is determined using job order costing, with each custom order considered a separate job. Print Done i Data Table - X Cutting Department Beginning balance Started in March Direct materials added in March Conversion costs Completed and transferred to Sewing Ending balance Amount Units $ 0 Oshirts 1,600 shirts 2,080 2,400 ??? 1.600 shirts 0 0 shirts Print Print Done Done i Data Table Job 367 368 369 370 Quantity 200 50 150 400 Design Fee Yes No Yes Yes Printing 4 colors 5 colors 2 colors 5 colors Status Complete Complete Complete Complete The New Orleans Shirt Company has previously determined that creating and programming the design cost $100 per design. This is a one-time charge. If a customer places another order with the same design, the customer is not charged a second time. Additionally, the cost to print is $0.30 per color per shirt. Print Done * Requirements - X 1. Complete a production cost report for the Cutting Department and the Sewing Department. What is the cost of one basic shirt? 2. Determine the total cost and the average cost per shirt for jobs 367, 368, 369, and 370. If the company set the sales price at 140% of the total cost, determine the total sales price of each job. 3. In addition to the custom jobs, the New Orleans Shirt Company sold 1,500 basic shirts (assume the beginning balance in Finished Goods Inventory is sufficient to make these sales, and the unit cost of the basic shirts ir Finished Goods Inventory is the same as the unit cost incurred this If the company set the sales price at 125% of the cost, determine the sales price per unit, total sales revenue, total cost of goods sold, and total gross profit for the basic shirts. 4. Calculate the total revenue, total cost of goods sold, and total gross profit for all sales, basic and custom. 5. Assume the company sold only basic shirts (no custom designs) and incurred fixed costs of $800 per month a. Calculate the contribution margin per unit, contribution margin ratio, required sales in units to break even, and required sales in dollars to break even b. Determine the margin of safety in units and dollars c. Graph New Orleans Shirt Company's CVP relationships. Show the breakeven point, the sales revenue line, the fixed cost line, the total cost line, the operating loss area, and the operating income area. d. Suppose the New Orleans Shirt Company wants to earn an operating income of $1,800 per month. Compute the required sales in units and dollars to achieve this profit goal. 6. The New Orleans Shirt Company is considering adding a new product line, a cloth shopping bag with custom screen printing that will be sold to grocery stores. If the current market price of cloth shopping bags is $1.25 and the company desires a net profit of 20%, what is the target cost? The company estimates the full product cost of the cloth bags will be $0.80. Should the company manufacture the cloth bags? Why or why not? Print Done The New Orleans Shirt Company makes two types of T-shirts: basic and custom. (Click the icon to view the additional information.) For the same time period, the New Orleans Shirt Company compiled the following data for the Custom Design Department: (Click the icon to view the Custom Design data.) For March 2018, the New Orleans Shirt Company compiled the following data for the Cutting and Sewing Departments: E (Click the icon to view the Cutting data.) Read the requirements. (Click the icon to view the Sewing data.) A More Info - X Basic shirts are plain shirts without any screen printing on them. Custom shirts are created using the basic shirts and then adding a custom screen printing design. The company buys cloth in various colors and then makes the basic shirts in two departments, Cutting and Sewing. The company uses a process costing system (weighted average method) to determine the production cost of the basic shirts. In the Cutting Department, direct materials (cloth) are added at the beginning of the process and conversion costs are added evenly through the process. In the Sewing Department, no direct materials are added. The only additional material, thread, is considered an indirect material because it cannot be easily traced to the finished product. Conversion costs are added evenly throughout the process in the Sewing Department. The finished basic shirts are sold to retail stores or are sent to the Custom Design Department for custom screen printing. The Custom Design Department creates custom shirts by adding screen printing to the basic shirt. The department creates a desian based on the customer's re then prints the design using up to four colors. Because these shirts have the custom printing added, which is unique for each order, the additional cost incurred is determined using job order costing, with each custom order considered a separate job. Print Done i Data Table - X Cutting Department Beginning balance Started in March Direct materials added in March Conversion costs Completed and transferred to Sewing Ending balance Amount Units $ 0 Oshirts 1,600 shirts 2,080 2,400 ??? 1.600 shirts 0 0 shirts Print Print Done Done i Data Table Job 367 368 369 370 Quantity 200 50 150 400 Design Fee Yes No Yes Yes Printing 4 colors 5 colors 2 colors 5 colors Status Complete Complete Complete Complete The New Orleans Shirt Company has previously determined that creating and programming the design cost $100 per design. This is a one-time charge. If a customer places another order with the same design, the customer is not charged a second time. Additionally, the cost to print is $0.30 per color per shirt. Print Done * Requirements - X 1. Complete a production cost report for the Cutting Department and the Sewing Department. What is the cost of one basic shirt? 2. Determine the total cost and the average cost per shirt for jobs 367, 368, 369, and 370. If the company set the sales price at 140% of the total cost, determine the total sales price of each job. 3. In addition to the custom jobs, the New Orleans Shirt Company sold 1,500 basic shirts (assume the beginning balance in Finished Goods Inventory is sufficient to make these sales, and the unit cost of the basic shirts ir Finished Goods Inventory is the same as the unit cost incurred this If the company set the sales price at 125% of the cost, determine the sales price per unit, total sales revenue, total cost of goods sold, and total gross profit for the basic shirts. 4. Calculate the total revenue, total cost of goods sold, and total gross profit for all sales, basic and custom. 5. Assume the company sold only basic shirts (no custom designs) and incurred fixed costs of $800 per month a. Calculate the contribution margin per unit, contribution margin ratio, required sales in units to break even, and required sales in dollars to break even b. Determine the margin of safety in units and dollars c. Graph New Orleans Shirt Company's CVP relationships. Show the breakeven point, the sales revenue line, the fixed cost line, the total cost line, the operating loss area, and the operating income area. d. Suppose the New Orleans Shirt Company wants to earn an operating income of $1,800 per month. Compute the required sales in units and dollars to achieve this profit goal. 6. The New Orleans Shirt Company is considering adding a new product line, a cloth shopping bag with custom screen printing that will be sold to grocery stores. If the current market price of cloth shopping bags is $1.25 and the company desires a net profit of 20%, what is the target cost? The company estimates the full product cost of the cloth bags will be $0.80. Should the company manufacture the cloth bags? Why or why not? Print Done