A Ltd specialises in the distribution of pharmaceutical products. It buys from pharmaceutical companies and re-sells to each of the three different distribution channels: (i) General supermarket chains, (ii) Drug store chains, and (iii) Individual chemist shops. The company plans to use activity-based costing for analysing the profitability of its distribution channels. The following data relates to the quarter ending March 2020. Particulars General supermarket chains Drug store chains Individual chemist shops Average sales per delivery $96,500 $32,450 $6,225 Average cost of goods sold per delivery $94,650, $31,800, $5,950 Number of deliveries 960 ,2,470, 8,570 Number of orders 1,000, 2,650, 9,500 Average number of cartons shipped per delivery 250 75 12 Average number of hours of shelf stocking per delivery 2, 0.5, 0.1 The following information is available in respect of operating costs (other than cost of goods sold) for the quarter ending March 2020. Activity areas Cost Cost driver Customer purchase order processing $591,750 Purchase orders by customers Customer store delivery $960,000 Number of deliveries Cartons dispatched to customer stores $792,135 Number of cartons dispatched to customer stores Shelf stocking at customer location $80,240 Hours of shelf stocking Required: (a) Calculate the activity cost driver rates for each of the activity areas. (b) Prepare an income statement showing details of each distribution channel for the quarter ending March 2020 using activity-based costing.
In: Accounting
Pearl Products Limited of Shenzhen China manufactures and distributes toys throughout South East Asia. Three cubic centimeters (cc) of solvent H300 are required to manufacture each unit of Supermix, One of the company's products. The company now is planning raw materials needs for the third quarter, the quarter in which peak sales of supermix occur. To keep production and sales moving smoothly, the company has the following inventory requirements:
a. The Finished goods inventrory on hand at the end of each month must equal 3,000 units of Supermix plus 20% of the next months sales. The finished goods invenroy on June 30 is budgeted to be 10,000 units.
b. The raw materials inventory on hand at the end of each month must equal one-half of the folwing months production needs for raw materials. The Raw materials inventory on June 30 is budgeted to be 54,000 cc of solvent H300.
c. The company maintains no work in process inventories. A monthly sales budget for Supermix for the third and fourth quarters of the year follows:
July- 35,000
August- 40,000
Septmeber 50,000
October 30,000
November 20,000
December 10,000
1. Prepare a productino budget for Supermix for the months July/ August/ September and October.
2. Examine the Production budget that you prepared in (1). Why will the cmopany produce more units than it sells in July and August and fewer units than it sells in September and October?
3. Prepare a direct materials budget showing the quantity of solvent H300 to be purchased for July, August, and September, and for the quarter in total.
In: Accounting
Pharma Save Ltd specialises in the distribution of pharmaceutical products. It buys from pharmaceutical companies and re-sells to each of the three different distribution channels: (i) General supermarket chains, (ii) Drug store chains, and (iii) Individual chemist shops. The company plans to use activity-based costing for analysing the profitability of its distribution channels. The following data relates to the quarter ending March 2020.
|
General |
Drug store |
Individual |
||
|
Particulars |
supermarket |
chemist |
||
|
chains |
||||
|
chains |
shops |
|||
|
Average sales per delivery |
$96,500 |
$32,450 |
$6,225 |
|
|
Average cost of goods sold per delivery |
$94,650 |
$31,800 |
$5,950 |
|
|
Number of deliveries |
960 |
2,470 |
8,570 |
|
|
Number of orders |
1,000 |
2,650 |
9,500 |
|
|
Average number of cartons shipped per |
||||
|
delivery |
250 |
75 |
12 |
|
|
Average number of hours of shelf stocking |
||||
|
per delivery |
2 |
0.5 |
0.1 |
The following information is available in respect of operating costs (other than cost of goods sold) for the quarter ending March 2020.
|
Activity areas |
Cost |
Cost driver |
|
Customer purchase order processing |
$591,750 |
Purchase orders by customers |
|
Customer store delivery |
$960,000 |
Number of deliveries |
|
Number of cartons dispatched to |
||
|
Cartons dispatched to customer stores |
$792,135 |
customer stores |
|
Shelf stocking at customer location |
$80,240 |
Hours of shelf stocking |
Required:
In: Accounting
The following information is available for Pioneer Company:
Required:
Determine Pioneer's budgeted selling and administrative expenses for November and December.
Citrus Girl Company (CGC) purchases quality citrus produce from local growers and sells the produce via the Internet across the United States. To keep costs down, CGC maintains a warehouse, but no showroom or retail sales outlets. CGC has the following information for the second quarter of the year:
Required:
1. Compute the budgeted cost of purchases for each month in the second quarter.
2. Complete the budgeted income statement for each month in the second quarter.
In: Accounting
Exercise 7-10 Production and Direct Materials Budgets [LO7-3, LO7-4]
|
Pearl Products Limited of Shenzhen, China, manufactures and distributes toys throughout South East Asia. Three cubic centimeters (cc) of solvent H300 are required to manufacture each unit of Supermix, one of the company’s products. The company is now planning raw materials needs for the third quarter, the quarter in which peak sales of Supermix occur. To keep production and sales moving smoothly, the company has the following inventory requirements: |
| a. |
The finished goods inventory on hand at the end of each month must be equal to 2,000 units of Supermix plus 25% of the next month’s sales. The finished goods inventory on June 30 is budgeted to be 11,250 units. |
| b. |
The raw materials inventory on hand at the end of each month must be equal to one-half of the following month’s production needs for raw materials. The raw materials inventory on June 30 is budgeted to be 57,375 cc of solvent H300. |
| c. | The company maintains no work in process inventories. |
| A sales budget for Supermix for the last six months of the year follows. |
| Budgeted
Sales in Units |
|
| July | 37,000 |
| August | 42,000 |
| September | 52,000 |
| October | 32,000 |
| November | 22,000 |
| December | 12,000 |
| Required: | |
| 1. |
Prepare a production budget for Supermix for the months July, August, September, and October. |
| 3. |
Prepare a direct materials budget showing the quantity of solvent H300 to be purchased for July, August, and September, and for the quarter in total. |
In: Accounting
7. Using the income elasticity of demand to characterize goods
Data collected from the economy of Pokerville reveals that a 16% increase in income leads to the following changes:
| • | A 12% increase in the quantity of flops demanded |
| • | A 14% decrease in the quantity of spades demanded |
| • | A 28% increase in the quantity of houses demanded |
Compute the income elasticity of demand for each good and use the dropdown menus to complete the first column in the following table. Then, based on its income elasticity, indicate whether each good is a normal good or an inferior good. (Hint: Be careful to keep track of the direction of change. The sign of the income elasticity of demand can be positive or negative, and the sign confers important information.)
|
Good |
Income Elasticity of Demand |
Normal or Inferior Good |
|---|---|---|
| Flops | ||
| Spades | ||
| Houses |
Which of the following three goods is most likely to be classified as a luxury good ? Spades Houses Flops |
In: Economics
|
7. Using the income elasticity of demand to characterize goods Data collected from the economy of Cardtown reveals that a 13% increase in income leads to the following changes:
Compute the income elasticity of demand for each good and use the dropdown menus to complete the first column in the following table. Then, based on its income elasticity, indicate whether each good is a normal good or an inferior good. (Hint: Be careful to keep track of the direction of change. The sign of the income elasticity of demand can be positive or negative, and the sign confers important information.)
|
In: Economics
Inventory Costing Methods-Periodic Method Chen Sales Corporation uses the periodic inventory system. On January 1, 2012, Chen had: 1,000 units of product A with a unit cost of $30 per unit. A summary of purchases and sales during 2012 follows:
| Unit Cost |
Units Purchased |
Units Sold |
|
|---|---|---|---|
| Feb.2 | 400 | ||
| Apr.6 | $32 | 1,800 | |
| July 10 | 1,600 | ||
| Aug.9 | 36 | 800 | |
| Oct.23 | 800 | ||
| Dec.30 | 39 | 1,200 |
Required
Do not round until your final answers. Round your answers to the nearest dollar.
| a. | First-in, First-out: | |
| Ending Inventory | ||
| Cost of Goods Sold | ||
| b. | Last-in, first-out: | |
| Ending Inventory | ||
| Cost of Goods Sold | ||
| c. | Weighted Average | |
| Ending Inventory | ||
| Cost of goods sold |
d. Assuming that Chen’s products are perishable items, which of
the three inventory costing methods would you choose to:
Assume this is during a period of rising costs.
| 1. Reflect the likely goods flow through the business? | AnswerFirst-in, first outLast-in, first outWeighted-average cost |
| 2. Minimize income taxes for the period? | AnswerFirst-in, first outLast-in, first outWeighted-average cost |
| 3. Report the largest amount of net income for the period? | AnswerFirst-in, first outLast-in, first outWeighted-average cost |
Please answer all parts of the question.
In: Accounting
Inventory Costing Methods-Periodic Method Chen Sales Corporation uses the periodic inventory system. On January 1, 2012, Chen had: 1,000 units of product A with a unit cost of $70 per unit. A summary of purchases and sales during 2012 follows:
| Unit Cost |
Units Purchased |
Units Sold |
|
|---|---|---|---|
| Feb.2 | 400 | ||
| Apr.6 | $72 | 1,800 | |
| July 10 | 1,600 | ||
| Aug.9 | 76 | 800 | |
| Oct.23 | 800 | ||
| Dec.30 | 79 | 1,200 |
Required
Do not round until your final answers. Round your answers to the nearest dollar.
| a. | First-in, First-out: | |
| Ending Inventory | Answer | |
| Cost of Goods Sold | Answer | |
| b. | Last-in, first-out: | |
| Ending Inventory | Answer | |
| Cost of Goods Sold | Answer | |
| c. | Weighted Average | |
| Ending Inventory | Answer | |
| Cost of goods sold | Answer |
d. Assuming that Chen’s products are perishable items, which of
the three inventory costing methods would you choose to:
Assume this is during a period of rising costs.
| 1. Reflect the likely goods flow through the business? | AnswerFirst-in, first outLast-in, first outWeighted-average cost |
| 2. Minimize income taxes for the period? | AnswerFirst-in, first outLast-in, first outWeighted-average cost |
| 3. Report the largest amount of net income for the period? | AnswerFirst-in, first outLast-in, first outWeighted-average cost |
In: Accounting
1.Assume you collected a quarterly sales data (in millions of dollars) over a four-year period from the first quarter 2016 to the fourth quarter 2019, and computed the seasonal index for each quarter. If the values of the actual sales and deseasonalised sales were 162 and 158.68, respectively, in the second quarter of 2016, what is the (normalised) seasonal index for the second quarter? Round your answer to two decimal places.
2.
Assume you collected data representing the number of full-time employed males ('000) without access to paid leave entitlements in Australia from 1992 to 2007, and fitted a third-order autoregressive model. What number of degrees of freedom do you use if you test the appropriateness of the fitted model.
3.
The following are prices and consumption quantities for three commodities in 2009 and 2019:
| Commodity | 2009 | 2019 | ||
| Price | Quantity | Price | Quantity | |
| A | $2 | 15 | $5 | 17 |
| B | $32 | 4 | $28 | 3 |
| C | $5 | 20 | $7 | 15 |
Based on the above information, calculate the Laspeyres aggregate price index for 2019 using 2009 as the base year. Round your final answer to two decimal places.
In: Economics