Managerial Accounting

Hi CH Tutor! Please help me to answer these questions on Microsoft Excel. We need the one-by-one solution for these. If you follow the instructions, I will give you positive feedback. Thank you.

Selected information of the famous "Pandesal de Espesyal" of Shinra Breads and Pastries are presented below: Variable Fixed Direct materials 2.60 Direct labor 0.80 Factory OH 0.10 40,000 Selling expenses 0.25 40,000 Admin. Expenses 200,000 Selling price 9.00 Supposed the following proposal has taken place aside from the regular 50,000 production out of its 75,000 capacity. Proposal A demands for a 50,000 bulk order but at a discounted price of 6.50 each and thus sacrificing some of its regular customers.II Proposal B calls for a 20,000.00 rush order of Pandesal but the customer demands for additional cheese and first class flour that will increase the raw materials cost by 1.50 and since it is a rush order additional fixed costs of 40,000.00 will be incurred as overtime payment to the quality inspector and other administrative personnel. additional 0.20 will be incurred also as variable labor costs for overtime and night differential pay of laborers. However. the customer is willing to pay at a prime price of 12.00 for this rush purchased order request. 60. if the company accepts proposal A, effect on net income or loss would be: a. net loss recovery by 11,250.00 b. net loss recovery by 6,250.00 c. profit will increase by 6,250.00 (1. profit will increase to 6,250.00 61. Suppose instead of proposal A, the company chooses proposal B. the effect on net income or loss would be: a. net prot will increase by 73,500.00 b. net profit will increase to 91,000.00 c. net loss recovery by 73,500.00 (1. net profit will increase to 73500.00 62. 63. Yufe Stuff Toy manufactures and sells dolls. The following infonnation relates to operating results for the last quarter: Inventor}.r Beg. 500.00 Add: Units produced 20,000.00 Total available for sale 20,500.00 Less: Inventory end 1,125.00 Units sold 19,325.00 Breakeven point in no. of toys 15,500.00 Breakeven point in peso sales 65,325.00 Total xed costs 42,225.00 What is the company's variable cost per doll'.' a. 4.25 e. 1.20 b. 3.05 d. 0.96 Eiko Coir; operating percentages were as follows: Revenues 100.00% Costs of goods sold Variable 50.00% Fixed 10.00% 60.00% Gross prot 40.00% Other Operating Exp. Variable 20.00% Fixed 15.00% 35.00% Operating income 5.00% Eiko's sales totaled to 2,000,000.00. At what revenue level would the company breakeven'.' a. 1,900,000.00 e. 1,250,000.00 13. 1,666,662.00 d. 833,333.00 64. Auron Inc. manufactures and sells key rings embossed with college names and slogans. Last year, the key rings sold for 75.00 each and variable costs to manufacture them were 22.50 per unit. The company needed to sell 20,000 key rings to breakeven. The pretax income last year was 50,400.00. The company expects the following on the current year: Selling price of the key rings will be 90.00 Variable costs will be increased by one-third Fixed cost will increase by 10.00% . The income tax rate of 30% remains unchanged.66. 67. 68. For the company to breakeven to the coming year, the company should sell: a. 21,600 key rings c. 21,250 key rings in. 2,600 key rings d. 19,250 key rings lecth has revenues of 500,000.00, dependent costs of 300,000.00, and a pretax prot of 150,000.00. If the company increaSed the sales price per unit by 10.00%, reduced independent costs by 20.00% and left variable cost per unit unchanged, what would be the new breakeven point in pesos? a. 88,000.00 c. 110,000.00 33. \"$000.00 d. 125,000.00 Sepiroth Corp. has a contribution margin ratio of 26.00%. It aims to have a net income of 320,000.00 with a sales volume of 2,000,000.00. Its total fixed costs amount to: a. 200,000.00 c. 230,722.00 b. 83,20000 d. 520,000.00 A retail company determines its selling price by marking up variable costs by 60%. In addition. the company uses frequent selling pI'lCC markdown to stimulate sales. 1f the markdown average 10%, what is the company contribution margin ratio? a. 27.50% c. 32.50% b. 30.60% d. 41.20% Which of the following would decrease unit contribution margin the most? a. A 15.00% decrease in selling price 13. A 15.00% increase in variable costs c. A 15.00% decrease in variable costs (1. A 15.00% decrease in xed costs 69. A company produced 500 units of a product and incurred the following costs. Direct materials, 8,000.00; direct labor, 10,000.00 and overhead (20% fixed), 45,000.00. If the sales value of 500 units is 102,000.00, what is the contribution margin percentage? a. 44.00% c. 53.00% b. 47.00% d. 74.00%