Skip to content

平成21年度 秋期 ITパスポート試験 問92

This question's explanation and your answers so far.

問92
頻出度★★★

S社の販売管理業務は,受注処理,出荷処理及び請求処理で構成されており,業務効率の向上を目的として販売管理システムを利用している。 販売管理業務の概要と販売管理システムの概要は,次のとおりである。 〔販売管理業務の概要〕 (1) 受注処理では,営業担当者が顧客から注文依頼を受けると,受注データを販売管理システムに登録する。注文には,通常注文と優先注文の二つの種別がある。 (2) 出荷処理では,受注データを基に在庫引当を行う。通常注文は在庫数の70%まで引当可能であり,優先注文は在庫数まで引当可能である。在庫引当ができた分は,倉庫担当者が納品書を作成して出荷作業を行う。在庫引当ができなかった分は,次の入荷を待ってから出荷する。 (3) 請求処理では,毎月20日を請求締め日として,その翌日に経理担当者が出荷済データから顧客ごとに請求書を作成して送付する。 〔販売管理システムの概要〕 販売管理システムでは,受注処理,出荷処理,請求処理の結果が,それぞれ,受注管理ファイル,出荷管理ファイル,請求管理ファイルに登録される。 請求処理において,顧客 P 社との取引が次の表のとおりであったとき,e に入る請求金額は幾らか。

日付処理金額(円)
10/18受注20,000
10/21請求250,000
10/30出荷20,000
11/3受注30,000
11/5受注40,000
11/6出荷30,000
11/10受注35,000
11/15出荷40,000
11/20受注50,000
11/21請求e
11/25出荷35,000
出典 平成21年度 秋期 ITパスポート試験 問92
解説

問 92

  • Incorrectア

    70,000 yen is the sum of only the November shipments (30,000 on 11/6 plus 40,000 on 11/15). The shipment of 20,000 yen on 10/30 took place after the billing on 10/21, so it has not been billed yet and must be included in the 11/21 billing. This error arises from thinking that only shipments in the same month as the billing count.

  • イ

    正解 Billing is based on the shipped data, with a cut-off on the 20th of each month and the invoice prepared on the following day, the 21st (outline of operations (3)). Therefore, billing e on 11/21 includes only what was actually shipped after the previous billing on 10/21 and up to the 11/20 cut-off. Following the shipment rows in the table, the shipment of 20,000 yen on 10/30, 30,000 yen on 11/6, and 40,000 yen on 11/15 fall in this period, totaling 20,000+30,000+40,000=90,000 yen. The shipment of 35,000 yen on 11/25 is recorded in the table after the 11/21 billing row and is past the cut-off date, so it is carried over to the next billing (12/21). Also keep in mind that an order received is only a record that an order was taken; it does not become subject to billing until the shipment is completed. Therefore the correct answer is イ, 90,000 yen.

  • Incorrectウ

    105,000 yen is the sum of 30,000 on 11/6, 40,000 on 11/15, and 35,000 on 11/25. The 11/25 shipment is past the 20th cut-off and, in the table as well, is recorded after the 11/21 billing row, so it is not included in this billing. In addition, it wrongly leaves out the 10/30 shipment.

  • Incorrectエ

    155,000 yen is the sum of the four orders received after the previous billing on 10/21 (30,000 on 11/3, 40,000 on 11/5, 35,000 on 11/10, and 50,000 on 11/20); it is the error of totaling on an order-received basis. Billing processing is performed based on the shipped data, so amounts that have only been ordered and not yet shipped must not be billed.

ここがポイント
  • Billing processing is based on the shipped data. An order received (a record that an order was taken) is not subject to billing; you can bill only after the shipment has been completed.
  • The relationship between the cut-off date and the billing date: if the cut-off is the 20th of each month and billing is on the 21st, the target is the shipments made after the previous billing and up to the current cut-off date, while shipments after the cut-off date are carried over to the next billing.

Your answers