Survey of Accounting Packet 15 Semester Case - Cowboy Ice Cream, Inc. (cont.) As he prepares to operate both divisions of CIC for the first time, W.T. is unsure how to allocate the above costs. However, he does have estimates for the first month of planned operations of the ice cream truck (May). He plans to hire two part-time employees, who will each be guaranteed 20 hours per week, with the truck operating seven days a week. Including benefits and taxes, each employee will cost CIC $15 per hour. For May, the employees will work an estimated 180 total hours. For the truck, CIC orders ice cream from the manufacturer in bar form. Each bar costs $1.25. Based on previous summer operations, W.T. anticipates that 3,500 bars will be sold in May. He also anticipates that $100 will be spent on napkins and other paper supplies required to operate the truck. The bars for retail sale will be stored with the wholesale inventory. Inventory needed for the retail division will be picked up daily using the ice cream truck. Storage space is billed based on average square feet used on a monthly basis. For May, W.T. anticipates that storage and delivery charges will be $2,500. Delivery represents 40% of the amount charged. The manufacturer provides delivery to the cold storage facility and only the wholesale division requires delivery to its customers. The ice cream bars (only sold by the retail division) occupy about 20% of the space rented at the cold storage facility. For May, W.T anticipates that $2,000 of gas will be required to operate the ice cream truck In the summer months, W.T. anticipates he will work more hours and plans to pay himself a salary of $1,500 to manage the business. He anticipates he will work 180 hours in May, with 54 of those hours spent managing the retail division. W.T. also anticipates he will use $75 on administrative supplies during May. Finally, for May, he anticipates that the wholesale division will sell 4,000 units with an average manufacturing cost of $4.75 per unit. (a) Determine the estimated total cost and cost per unit for each division. Round all intermediate costs to the nearest whole cent. (b) Are there other costs W.T. should likely take into consideration? Survey of Accounting Packet 15 Cost Driver Cost items Total Cost to be Allocated Retail Amount Amount Allocated Allocated to the to Each Division Unit Wholesale Amount Amount Allocated Allocated to the to Each Division Unit 1. Wages of workers assigned to operate the ice cream truck, 2. Administrative Supplies 3.W.T.'s salary to complete administrative duties for the business. 4. Ice cream sold to wholesale and retail customers. 5. Cost of paper goods to operate the ice cream truck 6. Depreciation on the ice cream truck. 7a. Storage fees for ice cream sold to wholesale and retail customers. 76. Transportation fees for ice cream sold to wholesale customers. 8. Gas expense to operate ice cream truck. Total Survey of Accounting Packet 15 Semester Case - Cowboy Ice Cream, Inc. (cont.) As he prepares to operate both divisions of CIC for the first time, W.T. is unsure how to allocate the above costs. However, he does have estimates for the first month of planned operations of the ice cream truck (May). He plans to hire two part-time employees, who will each be guaranteed 20 hours per week, with the truck operating seven days a week. Including benefits and taxes, each employee will cost CIC $15 per hour. For May, the employees will work an estimated 180 total hours. For the truck, CIC orders ice cream from the manufacturer in bar form. Each bar costs $1.25. Based on previous summer operations, W.T. anticipates that 3,500 bars will be sold in May. He also anticipates that $100 will be spent on napkins and other paper supplies required to operate the truck. The bars for retail sale will be stored with the wholesale inventory. Inventory needed for the retail division will be picked up daily using the ice cream truck. Storage space is billed based on average square feet used on a monthly basis. For May, W.T. anticipates that storage and delivery charges will be $2,500. Delivery represents 40% of the amount charged. The manufacturer provides delivery to the cold storage facility and only the wholesale division requires delivery to its customers. The ice cream bars (only sold by the retail division) occupy about 20% of the space rented at the cold storage facility. For May, W.T anticipates that $2,000 of gas will be required to operate the ice cream truck In the summer months, W.T. anticipates he will work more hours and plans to pay himself a salary of $1,500 to manage the business. He anticipates he will work 180 hours in May, with 54 of those hours spent managing the retail division. W.T. also anticipates he will use $75 on administrative supplies during May. Finally, for May, he anticipates that the wholesale division will sell 4,000 units with an average manufacturing cost of $4.75 per unit. (a) Determine the estimated total cost and cost per unit for each division. Round all intermediate costs to the nearest whole cent. (b) Are there other costs W.T. should likely take into consideration? Survey of Accounting Packet 15 Cost Driver Cost items Total Cost to be Allocated Retail Amount Amount Allocated Allocated to the to Each Division Unit Wholesale Amount Amount Allocated Allocated to the to Each Division Unit 1. Wages of workers assigned to operate the ice cream truck, 2. Administrative Supplies 3.W.T.'s salary to complete administrative duties for the business. 4. Ice cream sold to wholesale and retail customers. 5. Cost of paper goods to operate the ice cream truck 6. Depreciation on the ice cream truck. 7a. Storage fees for ice cream sold to wholesale and retail customers. 76. Transportation fees for ice cream sold to wholesale customers. 8. Gas expense to operate ice cream truck. Total
