Question: if possible please answer the question in the same format as given in the excel ( use the same vocalbulary and order of the excel

if possible please answer the question in the same format as given in the excel ( use the same vocalbulary and order of the excel and format , answer the gray shaded cells ) thankyou  if possible please answer the question in the same format as
given in the excel ( use the same vocalbulary and order of

. Crescent Company produces stuffed toy animals, one of these is "Arabeau the Cow. Each Arabeau takes 0.20 yard of fabric (white with irregular black splotches) and eight ounces of polyfiberfill. Fabric costs $3.50 per yard and polyfiberfill is $0.05 per ounce. Crescent has budgeted production of Arabeaus for the next four months as follows: October November December January Units 42,000 90,000 50,000 40,000 Inventory policy requires that sufficient fabric be in ending monthly inventory to satisfy 20 percent of the following month's production needs and sufficient polyfiberfill be in inventory to satisfy 40 percent of the following month's production needs. Inventory of fabric and polyfiberfill at the beginning of October equals exactly the amount needed to satisfy the inventory policy. Each Arabeau produced requires (on average) 0.10 direct labor hour. The average cost of direct laboris $15 per hour. Enter the appropriate amounts in the shaded cells in columns D, F, H, and J. Crescent Company Direct Materials Purchases Budget for Fabric For the Fourth Quarter October November December Total Units produced * DM per unit (yards) Production needs Desired ending inventory (yards) Total needed Less: Beginning inventory Direct materials to be purchased * Cost per yard Total purchase cost Total Crescent Company Direct Materials Purchases Budget for Polyfiberfill For the Fourth Quarter October November December Units produced * DM per unit (ounces) Production needs Desired ending inventory (ounces) Total needed Less: Beginning inventory Direct materials to be purchased x Cost per ounce Total purchase cost Crescent Company Direct Labor Budget For the Fourth Quarter October November December Total Units produced * Direct labor time per unit (hours) Direct labor hours needed x Cost per direct labor hour Total direct labor cost

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!