Background It is the 1st April 2021. Jang is the Management Accountant for the business Chinese Lantern Imports. Based on the previous month sales (March 2021) Jang sets the following targets for April 2021. April 2021 targets Targeted Lantern sales = 2,300 units Targeted Lantern unit price = $230 (per lantern) Jang calculates the cost of the Lanterns he will need to purchase in during the month as 50% of the expected sales revenue. However, at the 1st April 2021, Jang already currently has $12,400 of Lanterns stock already in his shop. Jang does not intend to buy an extra Lanterns for May 2021. Question Referring to above information, what is the cost of the Lanterns that Jang needs to purchase in, for the month of April? Select one: a. Cost of Lanterns to purchase in = $237,900 O b. Cost of Lanterns to purchase in = $0 O c. Cost of Lanterns to purchase in = $252,100 O d. Cost of Lanterns to purchase in = $264,500

Background It is the 1st April 2021. Jang is the Management Accountant for the business Chinese Lantern Imports. Based on the previous month sales (March 2021) Jang sets the following targets for April 2021. April 2021 targets Targeted Lantern sales = 2,300 units Targeted Lantern unit price = $230 (per lantern) Jang calculates the cost of the Lanterns he will need to purchase in during the month as 50% of the expected sales revenue. However, at the 1st April 2021, Jang already currently has $12,400 of Lanterns stock already in his shop. Jang does not intend to buy an extra Lanterns for May 2021. Question Referring to above information, what is the cost of the Lanterns that Jang needs to purchase in, for the month of April? Select one: a. Cost of Lanterns to purchase in = $237,900 O b. Cost of Lanterns to purchase in = $0 O c. Cost of Lanterns to purchase in = $252,100 O d. Cost of Lanterns to purchase in = $264,500

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

ChapterMB: Model-building Problems

Section: Chapter Questions

Problem 22M

See similar textbooks

Similar questions

Prepare journal entry to record the expected sales return and cost of goods sold? Pinpong curtains sells with an unconditional sales return if its customers are not satisfied. The sales returns extends 60 days. On February 10, 2021, a customer purchases 4,000 of products (cost 2,000). Assuming that based on prior experience, estimated returns are 20%.
Springton makes and sells a single product, black handbags, at a price of $1,600 each. During the three months to December 31,2020, he sold 1,500 handbags and turnover was the same for each month. He expects the volume of sales to remain unchanged for January 2021 but to increase by 5% in February, and by a further 20% in April. The price of the handbags will be increased by 10% in January and by a further 5% in June. The following budgeted information is presented to assist in the preparation. Month Budgeted sales $ Budgeted purchases $ January 880,000 600,000 February 924,000 750,000 March 924,000 820,000 April 1,108,800 820,000 May 1,250,000 968,000 June 1,285,000 1,250,000 Notes: Effective January 1, 2021 Springton’s collection on sales will be as follows: 70% collected in the month of sale The balance will be collected one month following sale Required: Prepare a sales budget for the handbags…
Furniture, Inc., estimates the following number of mattress sales for the first four months of 2019: Month Sales January 32,000 February 36,800 March 29,600 April 43,200 Finished goods inventory at the end of December is 7,100 units. Target ending finished goods inventory is 20% of the next month's sales. Required: Calculate the How many mattresses should be produced in each month of the first quarter of 2019?
pos Ibie Furniture, Inc., estimates the following number of mattress sales for the first four months of 2019: Month Sales January February 22,000 39,800 March 28,600 April 44,200 Finished goods inventory at the end of December is 6,900 units. Target ending finished goods inventory is 10% of the next month's sales. How many mattresses should be produced in the first quarter of 2019? A. 92,340 mattresses B. 68,840 mattresses TE O C. 87,920 mattresses 1 a O D. 57,760 mattresses Mi F Ju fir https: Cha The es sales 4 Missing Calculator Next http://mi tho ?3 O O O O
Sara is considering whether to open a gadgets shop. She provided you, as a consultant, the following information: Sales of $60,000 and $72,000 are expected for July and August, respectively. All goods are sold on account. The collection pattern for Accounts Receivable is 80 percent in the month of sale and 20 percent in the month following the sale. Purchases of $40,000 and $54,000 are expected for July and August. The payment pattern for purchases is 70 percent in the month of purchase, 30 percent in the month following the purchase. Other monthly expenses are $8,000, which includes $2000 of depreciation. All operating expenses are paid in the month of their incurrence. $2,000 of cash is available on August 1, 2021. Required: Prepare the cash collection budget for the two months ending August 31, 2021 Prepare the cash budget for the two months ending August 31, 2021
Sylvester has a bird shop that sells canaries. Sylvester maintains accurate records on the number of birds purchased from its suppliers and the number sold to customers. The records show the following purchases and sales during 2021. Date Transactions Units Cost per Unit Total Cost January 1 Beginning inventory 34 $39 1,326 April 14 Purchase 79 41 3,239 August 22 Purchase 129 43 5,547 October 29 Purchase 94 45 4,230 336 14,342 Jan. 1–Dec. 31 Sales ($59 each) 279 Sylvester uses a periodic inventory system and believes there are 57 birds remaining in ending inventory. However, Sylvester neglects to make a final inventory count at the end of the year. An employee accidentally left one of the cages open one night and 10 birds flew away, leaving only 47 birds in ending inventory. Sylvester is not aware of the lost canaries. Required:1. What amount will Sylvester calculate for ending inventory and cost of goods sold using FIFO, assuming he erroneously…
Sylvester has a bird shop that sells canaries. Sylvester maintains accurate records on the number of birds purchased from its suppliers and the number sold to customers. The records show the following purchases and sales during 2021. Date Transactions Units Cost per Unit Total Cost January 1 Beginning inventory 34 $39 $1,326 April 14 Purchase 79 41 3,239 August 22 Purchase 129 43 5,547 October 29 Purchase 94 45 4,230 336 14,342 Jan. 1–Dec. 31 Sales ($59 each) 279 Sylvester uses a periodic inventory system and believes there are 57 birds remaining in ending inventory. However, Sylvester neglects to make a final inventory count at the end of the year. An employee accidentally left one of the cages open one night and 10 birds flew away, leaving only 47 birds in ending inventory. Sylvester is not aware of the lost canaries. 4. Assuming that ending inventory is correctly counted at the end of 2022, what effect will the inventory error in 2021 have on…
Sylvester has a bird shop that sells canaries. Sylvester maintains accurate records on the number of birds purchased from its suppliers and the number sold to customers. The records show the following purchases and sales during 2021. Date Transactions Units Cost per Unit Total Cost January 1 Beginning inventory 34 $39 $1,326 April 14 Purchase 79 41 3,239 August 22 Purchase 129 43 5,547 October 29 Purchase 94 45 4,230 336 14,342 Jan. 1–Dec. 31 Sales ($59 each) 279 Sylvester uses a periodic inventory system and believes there are 57 birds remaining in ending inventory. However, Sylvester neglects to make a final inventory count at the end of the year. An employee accidentally left one of the cages open one night and 10 birds flew away, leaving only 47 birds in ending inventory. Sylvester is not aware of the lost canaries. 2. What amount would Sylvester calculate for ending inventory and cost of goods sold using FIFO if he knew that only 47 canaries…
Sylvester has a bird shop that sells canaries. Sylvester maintains accurate records on the number of birds purchased from its suppliers and the number sold to customers. The records show the following purchases and sales during 2021. Date Transactions Units Cost per Unit Total Cost January 1 Beginning inventory 34 $39 $1,326 April 14 Purchase 79 41 3,239 August 22 Purchase 129 43 5,547 October 29 Purchase 94 45 4,230 336 14,342 Jan. 1–Dec. 31 Sales ($59 each) 279 Sylvester uses a periodic inventory system and believes there are 57 birds remaining in ending inventory. However, Sylvester neglects to make a final inventory count at the end of the year. An employee accidentally left one of the cages open one night and 10 birds flew away, leaving only 47 birds in ending inventory. Sylvester is not aware of the lost canaries. 3. What effect will the inventory error have on reported amounts for (a) ending inventory, (b) retained earnings, (c) cost of goods…
Sylvester has a bird shop that sells canaries. Sylvester maintains accurate records on the number of birds purchased from its suppliers and the number sold to customers. The records show the following purchases and sales during 2021. Date Transactions Units Cost per Unit Total Cost January 1 Beginning inventory 34 $39 $1,326 April 14 Purchase 79 41 3,239 August 22 Purchase 129 43 5,547 October 29 Purchase 94 45 4,230 336 14,342 Jan. 1–Dec. 31 Sales ($59 each) 279 Sylvester uses a periodic inventory system and believes there are 57 birds remaining in ending inventory. However, Sylvester neglects to make a final inventory count at the end of the year. An employee accidentally left one of the cages open one night and 10 birds flew away, leaving only 47 birds in ending inventory. Sylvester is not aware of the lost canaries. 2. What amount would Sylvester calculate for ending inventory and cost of goods sold using FIFO if he knew that only 47 canaries…
DER Corp will open a new store on January 1. Based on experience form its other retail outlets, DER is making the following sales projections: Cash sales Jan 600 000 Feb 300 000 Mar 400 000 Apr 400 000 Credit sales 400 000 500 000 600 000 800 000 DER Corp estimates that 70% of the credit sales will be collected in the month following the month of the sale, with the balance collected in the second month following the sale. 1. Based on these data, the balance in accounts receivable on January 31 will be increased by:
Sylvester has a bird shop that sells canaries. Sylvester maintains accurate records on the number of birds purchased from its suppliers and the number sold to customers. The records show the following purchases and sales during 2021. Date Transactions Units Cost per Unit Total Cost January 1 Beginning inventory 35 $40 $ 1,400 April 14 Purchase 80 42 3,360 August 22 Purchase 130 44 5,720 October 29 Purchase 95 46 4,370 340 $14,850 Jan. 1–Dec. 31 Sales ($60 each) 280 Sylvester uses a periodic inventory system and believes there are 60 birds remaining in ending inventory. However, Sylvester neglects to make a final inventory count at the end of the year. An employee accidentally left one of the cages open one night and 10 birds flew away, leaving only 50 birds in ending inventory. Sylvester is not aware of the lost canaries. Required: 1. What amount will Sylvester calculate for ending inventory and cost of goods sold using FIFO, assuming he erroneously believes…