Customer Order Form Custom Fabric Ventures Customer Order Form Customer: Katie’s Boutique Order Date: 10/2/2012 Order Due Date: 10/15/2012 Description:Model Number:QuantityUnit Sales PriceTotal...

Excel Spreadsheet and Instructionsfile:///C:/Users/EricJ/AppData/Local/Temp/Cost%20Project%20Direction%20for%20Excel%20File.pdf



Customer Order Form Custom Fabric Ventures Customer Order Form Customer: Katie’s Boutique Order Date: 10/2/2012 Order Due Date: 10/15/2012 Description:Model Number:QuantityUnit Sales PriceTotal Black & White HandbagBW149237$75$525 Estimated Annual Costs Type of CostEstimated total cost for the year Selling and Administrative salaries and expenses$ 210,000 Direct Labor (Estimated 40,000 DL hours @ average wage rate of $12 per hour)$ 480,000.00 Indirect plant labor$ 40,000 Plant utilities$ 50,000 Purchases of direct materials$ 1,400,000 Lease and property taxes on the plant$ 120,000 Marketing expenses$ 30,000 Depreciation on production equipment (equipment originally costing $700,000 three year ago is being depreciated over a 5 year useful life using straight-line depreciation. No salvage value is expected.) Indirect materials to be used in the plant$ 20,000 Calculate Predetermined Overhead Rate Bill of Materials BILL OF MATERIALS JOB 114 Model: BW14923 Number of units: Part NumberDescriptionQuantity needed per unitTotal Quantity Needed BWFFBlack and White Floral Fabric0.50yards BWCheckBlack and White Checkered Fabric0.75yards BFringeBlack Fringe Trim1.00yards BStrapBlack shoulder strapping1.75yards PlCanPlastic Canvas0.25sheets Int4Interfacing: Level 4 sturdiness rating0.50yards Production Schedule Production Schedule For the month of October Job Model NumberStock or CustomerQuantityScheduledScheduled End date Start Date 111Headbands - HB246Perreth20010/110/3 11214 inch pillows- P14Slothower3010/410/5 113Draperies- GB159Stock8010/610/9 114Black & White BW14923Katie’s & Stock Raw Materials Records Raw Materials Record Item No. BWFF Description: Black and White Floral Fabric ReceivedUsedBalance DateUnits (yards)CostTotalRequisitionUnits (yards)CostTotalUnits (yards)CostTotal Number 1-Oct6$6.00$ 36.00 Raw Materials Record Item No. BWCheck Description: Black & White Checkered Fabric ReceivedUsedBalance DateUnits (yards)CostTotalRequisitionUnits (yards)CostTotalUnits (yards)CostTotal Number 1-Oct20$8.00$160.00 3-Oct#678412$8.00$96.008$8.00$64.00 Raw Materials Record Item No. BFringe Description: Black Fringe Trim ReceivedUsedBalance DateUnits (yards)CostTotalRequisitionUnits (yards)CostTotalUnits (yards)CostTotal Number 1-Oct3$3.00$9.00 2-Oct60$3.00$180.0063$3.00$189.00 Raw Materials Record Item No. BStrap Description: Black Shoulder Strapping ReceivedUsedBalance DateUnits (yards)CostTotalRequisitionUnits (yards)CostTotalUnits (yards)CostTotal Number 1-Oct0$0.00 Raw Materials Record Item No. PlCan Description: Plastic Canvas Sheets ReceivedUsedBalance DateUnits (sheets)CostTotalRequisitionUnits (sheets)CostTotalUnits (sheets)CostTotal Number 1-Oct25$0.90$22.50 Raw Materials Record Item No. Int4 Description: Interfacing- level 4 ReceivedUsedBalance DateUnits (yards)CostTotalRequisitionUnits (yards)CostTotalUnits (yards)CostTotal Number 1-Oct50$4.00$200.00 4-Oct#678548$4.00$192.002$4.00$8.00 Suppliers JoAnne Fabrics- Commercial Division Part NumberNamePrice per yard GrFlorGreen Floral$6.50 FF620Funky Floral$3.25 J293Jacobean$12.00 DB524Denim Block$8.50 RD590Razzle Dazzle$3.50 AtoneAqua Tone$2.75 BWCheckBlack & White Check$7.00 GrSwirlGreen Swirel$9.50 PlCanPlastic Canvas$1.00 Int4Interfacing- level 4$4.00 Int 5Interfacing –level 5$4.50 RRHPinkRik Rak- Hot Pink$2.75 BBeadBlack Beads$5.75 BFringeBlack Fringe$3.00 OGStrapOlive Green Strapping$2.50 BStrapBlack Shoulder Strapping$2.00 Hancack Fabrics- Commercial Division Part NumberNamePrice per yard CPlaidCountry Plaid$7.50 BWCheckBlack &White Check$9.00 FF620`Funky Floral$3.50 DB524Denim Block$8.75 BWFFBlack & White Floral$6.00 RD590Razzle Dazzle$4.25 AtoneAqua Tone$3.25 ContsphContemporary Spheres$4.75 WS269Wavy Stripe$5.50 PlCanPlastic Canvas$1.00 Int4Interfacing- level 4$5.00 Int 5Interfacing –level 5$4.75 RRHPinkRik Rak- Hot Pink$3.00 BBeadBlack Beads$6.00 STBScalloped Trim$5.50 OGStrapOlive Green Strapping$2.75 Purchase Order- #1 Purchase Order Supplier: Date ordered: 10/3 Date needed by: Item NumberQuantityCost per yardTotal Cost TOTAL$ Purchase Order- #2 Purchase Order Supplier: Date ordered: 10/3 Date needed by: Item NumberQuantityCost per yardTotal Cost TOTAL$ Materials Requisition Materials Requisition Number: #6786 Date: Job: Part numberDescriptionQuantity NeededUnit CostTotal Cost BWFFBlack and White Floral Fabric BWCheckBlack and White Checkered Fabric BFringeBlack Fringe Trim BStrapBlack Shoulder Strapping PlCanPlastic Canvas Int4Interfacing: Level 4 rating Total Job Cost Record Job Cost Record Job Number: ______ Customer or Stock: ____________ Job description: ____________________________________ Date Started: _______ Date Completed: _________ Quantity:________ Manufacturing Cost Information:Cost Summary Direct Materials (list Materials Requisition # and cost)$ Direct Labor (list labor time record #, hours, and cost)$ Manufacturing Overhead (show calculation of amount allocated)$ Total Job Cost$ Number of units Cost per Unit$ Shipping Information: DateQuantityUnits remainingCost Balance in shippedInventory Labor Time Records Labor Time Record Employee: Tyler David Week: 10/8- 10/15 Hourly wage rate: $10 $ 10.00Record #: 324 DateJob numberStart TimeEnd TimeHoursCost 8-Oct1138:004:008$80 9-Oct11312:005:005$50 10-Oct1148:004:008$80 11-Oct1148:004:008$80 12-Oct1159:001:004$40 Labor Time Record Employee: Eli Kunde Week: 10/8- 10/15 Hourly wage rate: $15