1. Month sales for May and June are $200,000k and $210,000, respectively. Cost of Goods Sold (CGS) 65%. Variable Cost (VC) 20%. Monthly Fixec Costs (FC) $12,000. Depreciation included in FC $4,000. Ending inventory 40% of next month CGS. Beginning Inventory $52,000 for May. Find the sale budget for May?
1. $213,500 and $ 215,500
2. $230,000 and 231,500
3. $232,500 and $234,500
4. $234,500 and $246,500
5. none of the above
|
2. During last month, you are given the following data for MM Retail Store |
||
|
the available for sales |
$150,000 |
|
|
Ending inventory |
20% |
of Cost of goods sold |
|
Find cost of goods sold for the last month |
||
|
$100,000 |
||
|
$125,000 |
||
|
$150,000 |
||
|
$175,000 |
In preparing a flexible budget, we use
| a. |
expected costs at the actual level of activity |
|
| b. |
expected costs at the estimated level of activity |
|
| c. |
actual costs at the actual activity |
|
| d. |
actual costs at the budgeted activity |
Requirement 1: The correct option is “5” None of the above.
The budgeted sales revenue for the month of May is $200,000 and for June $210,000 respectively.
Requirement 2: The correct option is “2” $125,000
Let X cost of goods sold
X = Goods available for sale − Ending inventory
= $150,000 − (X × 20%)
1.20X = $150,000
X = $150,000 ÷ 1.20
= $125,000
Requirement 3: The correct option is ‘a’ Expected costs at the actual level of activity.
While preparing flexible budgets, expected total revenues and expected total costs are calculated for the actual level of activity.
1. Month sales for May and June are $200,000k and $210,000, respectively. Cost of Goods Sold...
Brandon Company has prepared the following sales budget: Month Budgeted Sales March $200,000 April 180,000 May 220,000 June 240,000 Cost of goods sold is budgeted at 40% of sales and the inventory at the end of February was $40,000. Desired inventory levels at the end of each month are 20% of the next month's cost of goods sold. What is the desired beginning inventory on June 1? So, beginning Inventory for June is ending inventory for May. End Inv May...
1. 2. 3. 4. Expected sales: June $507,300, July $608,800. Cost of goods sold is expected to be 75% of sales. Desired ending merchandise inventory is 30% of the following (next) month's cost of goods sol The beginning inventory at June 1 will be the desired amount. Compute the budgeted merchandise purchases for June. (Round answers to the nearest whole d GRAND STORES Merchandise Purchases Budget For the Month Ending June 30, 2017 Y if you would like to Show...
Hardy Company’s cost of goods sold is consistently 70% of sales. The company plans ending merchandise inventory for each month equal to 30% of the next month’s budgeted cost of goods sold. All merchandise is purchased on credit, and 40% of the purchases made during a month is paid for in that month. Another 45% is paid for during the first month after purchase, and the remaining 15% is paid for during the second month after purchase. Expected sales are:...
Myers Manufacturers has a sales budget for next month of $2000000. Cost of goods sold is expected to be 65 percent of sales. Accounts payable payments were $1414000 and ending accounts payable is $1625000. The beginning inventory of merchandise is $350000 and an ending inventory of $300000 is desired. 3 The beginning accounts payable for Myers Manufacturers should be A $1,300,000 B $1,789,000 C $1,414,000 D $2,275,000
Fosnight Enterprises prepared the following sales budget: Month March April May June Budgeted Sales $6,000 $12.000 $10,000 $11,000 The expected gross profit rate is 20% and the inventory at the end of February was $8,000. Desired Inventory levels at the end of the month are 20% of the next month's cost of goods sold. What is the desired ending Inventory on May 31? O A $440 OB. $1,600 OC. $8,800 OD. $1.760
April May June July $37,500 $34,000 $30,000 $45,000 Budgeted cost of goods sold Humboldt had a beginning inventory balance of $1,800 on April 1 and a beginning balance in accounts payable of $7,400. The company desires to maintain an ending inventory balance equal to 10 percent of the next period's cost of goods sold. Humboldt makes all purchases on account. The company pays 60 percent of accounts payable in the month of purchase and the remaining 40 percent in the...
Hardy Company's cost of goods sold is consistently 70 % of sales. The company plans ending merchandise inventory for each month equal to 20 % of the next month's budgeted cost of goods sold. All merchandise is purchased on credit, and 40% of the purchases made during a month is paid for in that month, Another 45 % is paid for during the first month after purchase, and the remaining 15% is paid for during the second month after purchase....
Hardy Company's cost of goods sold is consistently 60% of sales. The company plans ending merchandise Inventory for each month equal to 30% of the next month's budgeted cost of goods sold. All merchandise is purchased on credit, and 50% of the purchases made during a month is paid for in that month. Another 35% is paid for during the first month after purchase, and the remaining 15% pald for during the second month after purchase. Expected sales are: August...
Sander Enterprises prepared the following sales budget: Month March April May June Budgeted Sales $5000 137000 $14,000 $17.000 The expected gross profitrate is 10% and the inventory at the end of February was $13,000. Desired inventory levels at the end of the month are 20% of the next month's cost of goods sold. What are the total purchases budgeted for April? $11,520 $14,040 $11,880 $11,700
April May June July $ 500,000 $700,000 $400,000 $300,000 350,000 490,000 280,000 210,000 150,000 210,000 120,000 90,000 Sales Coat of goods sold Gross margin Selling and administrative expenses: Selling expense Administrative expense* Total selling and administrative expenses Net operating income 70,000 90,000 51,000 30,000 40,000 52, 800 32,000 28.000 110,000 142,800 83,000 58,000 $ 40,000 $ 67,200 $ $7,000 $32,000 "Includes $12,000 of depreciation each month. b. Sales are 20% for cash and 80% on account. c. Sales on account...